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?

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?

On Tue, 25 Aug 2009 12:48:05 -0700, 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?

Take a look at "Text to columns" that you find under "Data".

Hope this helps / Lars-Åke

Study MID Formula and see if it is usful to you or not.

You could have given some example so others can exactly understand your
requirement and study & answer.
--
Regards,
Pritesh


"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?