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?