Separate data in a column into new columns
 

Hi.

I have a column of data like this:

J32434 aspirin 5mg
J35453 heparin injection 10ml
J45345 vancomycin .05%

I want to separate the leading identifying JCode from the drug description.
Thus, making two more columns. Do you know how to do this?

Thanks in advance. Misty

--
Misty :-)

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200804/1

Separate data in a column into new columns
 

If always the same length of j32434 then just use datatext to columns

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mitchell_Collen via OfficeKB.com" <u33726@uwe wrote in message
news:82855c0b91a5f@uwe...
Hi.

I have a column of data like this:

J32434 aspirin 5mg
J35453 heparin injection 10ml
J45345 vancomycin .05%

I want to separate the leading identifying JCode from the drug
description.
Thus, making two more columns. Do you know how to do this?

Thanks in advance. Misty

--
Misty :-)

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200804/1