hi guys,

please help me? i've tried left and mid and trim but can't get to do the following;

cell B1 "abc123 1 2 3 adc"
Cell B2 "123adc123"
Cell B3 "1 b c 2 d e 123abc"

i need a fromula that will copy first 6 characters in cells in column b to new column only if as in B1. ie. first character is non numeric and first 6 characters are not seperated.

Please help me?

thx
DeeBee