+ Reply to Thread
Results 1 to 3 of 3

Same cell Alpha sort with variable number of items

  1. #1
    Registered User
    Join Date
    08-02-2021
    Location
    San Francisco
    MS-Off Ver
    2019
    Posts
    1

    Same cell Alpha sort with variable number of items

    I'm stuck with this issue. A cell has items separated by ; with multiple items and need it to sort in alpha. The number of items may vary (can have 1 to 30+) within one cell.

    Ex: Text in one column:

    Ba,Ca,Aa
    Ga,Da
    Ta,Ha,Ea,Xa

    Result:
    Aa,Ba,Ca
    Da,Ga
    Ea,Ha,Ta,Xa

    I can't find the right thread to deal with this... Hope this great board can help.

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Same cell Alpha sort with variable number of items

    I have found something similar here
    https://www.get-digital-help.com/sor...limiter-vba/#2
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Same cell Alpha sort with variable number of items

    UDF
    Use in cell like

    =SortInCell(A1,",")

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sort The list of items by Alpha / numeric in their proper sequential order
    By DON_BLACK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2013, 03:42 PM
  2. Replies: 8
    Last Post: 06-21-2013, 04:35 PM
  3. Sort on Alpha/Numeric cell
    By stephnjd in forum Excel General
    Replies: 3
    Last Post: 05-07-2013, 02:49 PM
  4. Custom Sort items not in alpha order
    By avidcat in forum Excel General
    Replies: 2
    Last Post: 12-10-2012, 07:32 PM
  5. How to Sort Numerically prefixed alpha numeric rows by Number
    By Shullay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2012, 08:36 PM
  6. Replies: 6
    Last Post: 04-14-2012, 04:07 AM
  7. Sort an Array of items by Alpha
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-07-2011, 04:59 PM
  8. Is there a way to sort items by the number of characters?
    By jdwilliams1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2006, 12:56 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1