Try this
=IF(LEN(B1)19,LEFT(B1,19),B1)
yellow281 Wrote:
Can I say genius.. :)
Thank you, it worked brilliantly... I cant quite there was a formula
for this!
May I challenge you again? My B column has up to 12 sets of codes each
seperated by a space in each cell. Is there a way I can tell the B
column to select the first 4 codes to retain them then delete the rest?
And if theres 4 codes or less to just leave the cell intact?
For example..
Before
B Column
*1234 3456 2356 8788* 5555 6789 0978 6342 1224 3244
After
B Column
1234 3456 2356 8788
Thank you!
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=391123