formula wanted please, I have a list of data
From: <jvoortman_at_sympatico.ca>
Date: 30 Jun 2006 19:48:44 -0700 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
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!! Received on Fri Jun 30 2006 - 19:48:47 PDT |
Click to report inappropriate content