Thread: sorting a concatenated cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wmack wmack is offline
external usenet poster
  
Posts: 1
Default sorting a concatenated cell

I have a cell that is entered FIRSTNAME, LAST NAME. What I have done is
using TRIM LEFT MID and Finally Concatenate, switched the First name
with the last name in a different column. Now all I want to be able to
do is to sort the cells alphabetically. I am sure that I need to use
another approach to this.


--
wmack
------------------------------------------------------------------------
wmack's Profile: http://www.excelforum.com/member.php...o&userid=37801
View this thread: http://www.excelforum.com/showthread...hreadid=573649

Reply With QuoteReply With Quote