View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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?