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

Suppose cell c5 contains the formula =b$6+c1
Logitech formula vibration feedback wheel driver - Download - Drivers
Excel grade formula - Guide
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Bloons td 6 free download - Download - Strategy

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

Please wait a few minutes to receive your 6-digit code before trying again.

How to calculate positions (1st,2nd,3rd...) in Excel

Highlight cell if another cell contains specific text

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!