opposite of concatenate?

  • Thread starter Thread starter BrightHawk
  • Start date Start date
B

BrightHawk

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.
 
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?
Click to expand...

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.
 
Back
Top