opposite of concatenate?
If they use common "dividers" take a look at Data - Text to Columns, and use
a delimiter as first option. Then choose your delimiter(s) as appropriate.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"BrightHawk" wrote:
I have multiple unique identifiers (item) in each cell of a spreadsheet,
separated by a comma and space, and I need to find a way to separate them so
there is only one identifier (item) per cell. Is that possible?
|