Jump to content

Featured Replies

Posted
  • FPCH Staff

I'm trying to take a list of items, reorder the data in a single cell, and then alphabetize the column. Alphabetizing the column is easy but reordering the data in a cell is tripping me up. I know I need to split by delimiter and recombine those cells but I'm unsure how to reorder.

 

Example of my data and what I'm looking to do:

 

 

 

 

 

 

 

 

Any help is much appreciated.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...