| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separate values in cell by delimiter
Have a look at "Text to columns" on the Data menu.
"JR" wrote: I have a particular cell in Excel that has multiple values defined in it and separated by a delimiter. Was wondering if someone could help me out with a macro that could parse this field down the spreadsheet and separate those values into new columns in the spreadsheet. So if Column C had: abc||cde||123 I would like columns F, G, and H to have: F would be abc G would be cde H would be 123 If Column C had 123||345||567||098 F would have 123 G would have 345 H would have 567 I would have 098 The number of values in C is not static and can vary. Thanks. JR |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
| Find One Of Several Values Within A Cell | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
