If cell contains 6 charactors copy them

Closed

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

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

Use the ifs function to return 5 if cell a5 contains the value 3
Gta 5 download apk pc - Download - Action and adventure
Hitman 3 cheats - Guide
Psiphon 3 download - Download - VPN
Forza horizon 5 download free - Download - Racing
Bluestacks 5 - Download - Android emulators

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 3, 2010 at 10:04 AM

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),""))

Similar discussions

help me to add particular cells

Excel function question

Excel - IF function with multiple words

If cell = date return yes or no.

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!