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
|