Re: Is text to rows possible?

I assume that the string will not always be the same length e.g you could have

1 x 610000394-2206

2 x 544454-223

2 x 65555454-44877

1x610045554400394-2227985554

If that is the case then in column B use the following formula

=IF(A1="","",MID(A1,(FIND("x",A1,1)+1),(FIND("-",A1,1)-(FIND("x",A1,1)+1))))

In column C use the following formula

=IF(A1="","",MID(A1,(FIND("-",A1,1)+1),(LEN(A1)-FIND("-",A1,1))))

This way it does not matter how long the Batch number is or the case number - you will always get them separated by using these formulas.

If they are always in the format of

1 x 610000394-2206 (9 numbers as Batch and 4 numbers as case always in the same format)

then the answer is much easier

Column B formula is =MID(A1,5,9)

Column C formula is = Right(A1,4)

Hope this helps

Anthony