formula wanted please, I have a list of data going down column "A"
only. When it was typed out they numbered each entry (if they would
have just done the numbering in a seperate column I wouldn't have this
question).

it looks like this;

1 assorted text
2 more assorted text
3 more assorted text

there are over 600 entries so I really don't want to do them manually.
I tried "text to column" and using the "fixed" choice but it chops
stuff up because some numbers like 1-9 have one digit while 10-99 have
2 digits and the hundreds have 3.

There is probably an easy way ......but I need your help...PLEASE!!