sorry Biff, I messed up. I tried it again but instead of pasting the
formula in cell b1, I selected cell b1 andthen pasted in the white
address box on the top. Not sure what the difference is, but the cell
didn' bloat, and now I can drag down and copy.THANK!!!!


wrote:
thnks Biff works ...sort of. When I past it in B1 it does what I want
it to but it makes the cell twice as tall thereby taking up B2 also.
This stops me from doing a fill down to do the whole list. Any ideas?
Thanks eh!


Biff wrote:
Hi!

Use a temporary helper column and enter this formula:

=MID(A1,FIND(" ",A1)+1,255)

Then convert those formulas to constants by doing:

EditCopy
EditPaste specialValues

Move the helper column and overwrite the original column.

Biff

wrote in message
ups.com...
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!!