View Single Post
  #1   Report Post  
andyholland
 
Posts: n/a
Default Combined & Sorted Text Fields


I have 12 columns of Letters that need to be combined into one cell in
the correct alphabetical order. Eg. Column 1 may have C whilst column 2
has B and so on. I need the last column to sort the letters
alphabetically so it would be simply BC in the last cell.

Any ideas?


--
andyholland
------------------------------------------------------------------------
andyholland's Profile: http://www.excelforum.com/member.php...o&userid=26491
View this thread: http://www.excelforum.com/showthread...hreadid=397574