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

[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

 

[Ron de Bruin]

Hi shadestreet

Use Data>Text to Columns in the menubar

 

[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)

Hi shadestreet

Use Data>Text to Columns in the menubar

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


"shadestreet >" <<[email protected]> wrote in

message news:[email protected]...

 

[shadestreet]

Thanks!

I knew there must have been a simple method.

*throws out partially completed Macro