IF Statement to retrieve specific length of text string

[Bob32103]

I have a column of text strings in Column E and I would like to have a formula in column F that returns only the text strings that are seven characters in length. If they are shorter or longer than seven characters then I would want the cells in Column F to be blank.

Would I do this via an IF statement or is there another method?

Thanks.


Bob

 

[silentwolf]

Hi,
=if(length(E2)=7;(E2);""))

hope this is correct in english excel as I am using german version...

HTH

 

[Bob32103]

Hi,
=if(length(E2)=7;(E2);""))

hope this is correct in english excel as I am using german version...

HTH

Thanks - it works. I just needed to change length to len.

 

[jtakw]

Hi,

You also don't need the brackets around E2 for value if true:

=IF(LEN(E2)=7,E2,"")

 

[silentwolf]

Hi,
great that you worked it out!

Cheers!