Can I seperate Text and Numbers from one cell, and drop into two cells?

S

shadestreet

I have a row of 1,400 entries, each is in the form:

"Some number" - "Some Text description"

e.g.:

450938-Magic Marker Blue
38272-Crayon Yellow
3888490-Lead Pencil
etc

I want to pull the numbers out of the cell and drop into their ow
cell, but without tediously going through each cell and retyping,
cannot think of an alternate method.

The only pattern here is that each set of numbers is between 5 and 1
characters, and that the text description is separated by a hyphe
"-".

Any ideas out there?
Thank
 
B

Bob Phillips

Ron's solution is best, but you can also do it with worksheet functions.

In B1, enter

=LEFT(A1,FIND("-",A1)-1)

and copy down.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Ron de Bruin said:
Hi shadestreet

Use Data>Text to Columns in the menubar

--
Regards Ron de Bruin
http://www.rondebruin.nl


"shadestreet >" <<[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
S

shadestreet

Thanks!

I knew there must have been a simple method.

*throws out partially completed Macro
 
Top