| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I parse one column into different columns?
I've inherited a big spreadsheet with a column that is full of entries
like "Symptom : PAIN Cause : INFECTION Rx : AMOXICILLIN Symptom : SORENESS Cause : STRAIN Rx : TYLENOL" Does anyone know of a good way to change this column into three separate columns like Symptom1 Cause1 Rx1 Symptom2 Cause2 Rx2 PAIN INFECTION AMOXICILLIN SORENESS STRAIN TYLENOL Thanks for any suggestions. (I've looked at a few books and couldn't find an example, and I thought somebody out there may have encountered this problem...) Kay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| Multiple columns of data into one long column | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
