Quote Originally Posted by stevekirk
hi,

I have a spread sheet that looks like this
TOP/BASE/SHELF 364X445
TOP/BASE/SHELF 364X445
TOP/BASE/SHELF 364X445
TOP/BASE/SHELF 764X445
TOP/BASE/SHELF 764X445
TOP/BASE/SHELF 764X445
TOP/BASE 764X499
TOP/BASE 764X499
TOP/BASE 764X499
FIXED SHELF 264X304
FIXED SHELF 264X304
364X448 INT FIXED SHELF
364X448 INT FIXED SHELF
364X448 INT FIXED SHELF
470X2600 SHELF
470X2600 SHELF
470X2600 SHELF

I would like to have all the descriptions first the all the numbers at the back which includes the x. the sixe of the text could vary

thanks

steve
I suppose that your data is in col A and starts from cell A1
put in B1 and copy it down

=IF(LEN(IF(ISNUMBER(MID(A1,1,2)*1),MID(A1,1,FIND(" ",A1)-1),A1))=LEN(IF(LEN(A1)=LEN(IF(ISNUMBER(MID(A1,1,2)*1),MID(A1,1,FIND(" ",A1)-1),A1)),A1,RIGHT(A1,LEN(A1)-LEN(IF(ISNUMBER(MID(A1,1,2)*1),MID(A1,1,FIND(" ",A1)-1),A1))-1))),IF(ISNUMBER(MID(A1,1,2)*1),MID(A1,1,FIND(" ",A1)-1),A1),IF(LEN(A1)=LEN(IF(ISNUMBER(MID(A1,1,2)*1),MID(A1,1,FIND(" ",A1)-1),A1)),A1,RIGHT(A1,LEN(A1)-LEN(IF(ISNUMBER(MID(A1,1,2)*1),MID(A1,1,FIND(" ",A1)-1),A1))-1))&" "&IF(ISNUMBER(MID(A1,1,2)*1),MID(A1,1,FIND(" ",A1)-1),A1))

let me know about results.

Regards.