checking a cell if it contains 6 characters

[Daehoon]

i have a cell i have to check if it contains six characters. I have a list of data that i need to narrow down to six characters. I have successfully done that, but some of the cell has 5, 6, or 7 characters. The list contains about 600 cells, but i don't have time to format them individually. I want to create a formula that returns true or false if the cell contains 6 characters and false if it is above or below 6.

Can somebody help me, i'm new to excel!

[royUK]

Use another column with this formula & copy down

=IF(LEN(A1)=6,"True","False")

[JBeaucaire]

Actually, the IF() is redundant. The test itself will return a TRUE/FALSE answer with just:

=LEN(A1)=6

[Daehoon]

THANK YOU SO MUCH!!!

i cant tell you how much i appreciate your help!

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[squiggler47]

Just reading the OP's question, if you wanted to add characters to the front or cut off one of the characters this can be done too!

=RIGHT(REPT("-",6) &RIGHT(B4,6),6)

will pad with - or will give the right most 6 letters or just return the original if its 6 long


=RIGHT(REPT("-",6) &LEFT(B4,6),6)

will do the same but return the left most 6 charaters if it is above 7

Just change the - after REPT to change the extra characters you want to add

I may be wrong but it sounds like this might help!