Microsoft Office Forums - View Single Post - [Solved] Copy data if the Cell A1 has 4 characters in total

Thread: [Solved] Copy data if the Cell A1 has 4 characters in total

View Single Post

Old

05-31-2018, 05:33 PM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

LearnerExcel uses Windows 7 32bit

Windows 7 32bit LearnerExcel uses Office 2013

LearnerExcel uses Office 2013

Office 2013

Advanced Beginner

The original poster

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

LearnerExcel will become famous soon enough

Default

I tried the following code which is working fine.

=IF(LEN(A1)<=4,A1,"")

Reply With Quote