Separate data in a column into new columns

[Mitchell_Collen via OfficeKB.com]

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

 

[Don Guillett]

If always the same length of j32434 then just use data>text to columns>