Separate data in a column into new columns

  • Thread starter Mitchell_Collen via OfficeKB.com
  • Start date
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to separate column data into headers 5
separate columns by numeric and letter values 5
separate columns (three letter code) 7
Moving cell data left 1
How to pull in data from rows and columns if there are blanks? 0
Downloaded CSV Data to Automatically Appear in Separate Columns 1
Splitting multiple cell contents from 1st column into 4 columns 3
Summing rows using formulas with variables 2

Top