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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Jun 2010 à 10:04
Related:
- Suppose cell c5 contains the formula =b$6+c1
- Excel cell color formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Ulead photo express 6 - Download - Image editing
- Credit summation formula - Guide
- Number to words in excel formula - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
3 Jun 2010 à 10:04
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),""))
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),""))