I'm a little unsure of what you are needing to do here. Get things back into
the original sequence? If so, you can try this (assuming column B is
available, otherwise, use another)

in B1
=REPT("0",3-(FIND(" ",A33)-1)) & A33
and drag down to the end of your list
1 some text
24 some more text
399 even more text

will appear as
001 some text
024 some more text
399 even more text

Then you can copy all of that and use Edit | Paste Special with the [Values]
option checked to turn that into 'real text' instead of formula results and
sort and get it back into the original sequence?

Now if I missed that target, here are formulas to actually split the entries
at the space after the number:
B1
=LEFT(A33,FIND(" ",A33)-1)
C1
=RIGHT(A33,LEN(A33)-FIND(" ",A33))


" wrote:

I would agree with you except that I was stupid enough to do a sort
whuile playing around with it. So now 2 comes after 19 but before 20
and then 21-29, the 200, 201 etc. Yeah I goofed up!

Mallycat wrote:
the easiest way I can think of is to do numbers 1-9 by hand, numbers 10
- 99 with text to columns fixed width then numbers 100 - 999 with a
different text to columns fixed width etc.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=557529