If cell contains 6 charactors copy them

Closed
Deanna - 3 Jun 2010 à 09:11
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Jun 2010 à 10:04
Hello,

I have a little problem I'm hoping someone can help with with. I appreciate any advice you can give me.

I have a column in excel that has 6 or ore charactors. If there are just 6 charactors, I would like it to copy those 6 to the new cell. If there are more than 6 charactors, I would like it to copy just the first three letters over. I'm not sure how to tell it to look for a certain # of charctors.

Thanks so much for your help!

Deanna


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
3 Jun 2010 à 10:04
try this formula

this assumes that if the length is less than 6 then do nothing

=IF(LEN(A1)=6, A1, IF(LEN(A1)>6,LEFT(A1,3),""))