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
|