Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
DataText to columns
Specify your own separator and tell Excel to treat multiple separators as one -- Kind regards, Niek Otten Microsoft MVP - Excel "JR" wrote in message oups.com... |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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |