Quote Originally Posted by stevekirk
hi,

if the numbers are at the front
i get an NAME result

steve
Hi steve,

Try this formula, move data down to start in A2, then put this in B2 and copy down

=IF(IF(ISNUMBER(MID(LEFT(A2,1),1,1)*1),LEFT(A2,1)*1,"")="",A2,IF(ISNUMBER(IF(ISNUMBER(MID(LEFT(A2,1),1,1)*1),LEFT(A2,1)*1,"")),RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1))&" "&LEFT(A2,8),""))

Let me know if this is OK

oldchippy