| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate data into two columns | Excel Discussion (Misc queries) | |||
| swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
| swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
| Separate address column to Five columns | Excel Worksheet Functions | |||
| split a single column into 2 separate columns | Excel Worksheet Functions | |||
Hybrid Mode
