Thread: Separate data in a column into new columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mitchell_Collen via OfficeKB.com Mitchell_Collen via OfficeKB.com is offline
external usenet poster
  
Posts: 27
Default 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

Reply With QuoteReply With Quote