LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically open .txt file with all fields as text? Jerry Excel Discussion (Misc queries) 2 June 28th 05 04:35 PM
Can I create and save a formula for text fields? Jason Excel Discussion (Misc queries) 2 June 21st 05 10:20 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Adding Two Text Fields together Audrey Excel Discussion (Misc queries) 2 February 24th 05 11:08 PM
i have fields that are formatted for text that randomly convert t. dave glynn Excel Discussion (Misc queries) 2 February 22nd 05 09:03 PM


All times are GMT +1. The time now is 05:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"