checking a cell if it contains 6 characters

1. checking a cell if it contains 6 characters

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!

2. Re: checking a cell if it contains 6 characters

Use another column with this formula & copy down

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

3. Re: checking a cell if it contains 6 characters

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

=LEN(A1)=6

4. Re: checking a cell if it contains 6 characters

THANK YOU SO MUCH!!!

i cant tell you how much i appreciate your help!

5. Re: checking a cell if it contains 6 characters

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

6. Re: checking a cell if it contains 6 characters

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!

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1