+ Reply to Thread
Results 1 to 3 of 3

Sorting the alphabetical order with semicolon in each cell.

  1. #1
    Registered User
    Join Date
    03-07-2012
    Location
    Durban, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    3

    Sorting the alphabetical order with semicolon in each cell.

    Hi guy

    I've google and trying find the solution so I've register and post if you can help

    So I've thousand of row that I require to sort out each single cell of the row here the sample below i'm explain.

    eg the cell contain "NatKey;CCC;HBC;CLIN;Legal"

    so I need a formula that it sort out "CCC;CLIN;HBC;Legal;NatKey"

    Hope it make sense to you

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Sorting the alphabetical order with semicolon in each cell.

    Try this user defined function.

    Please Login or Register  to view this content.
    Paste this into a new module in the VBA editor (AltF11) and type =SortSpecial(A1) in B2
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Registered User
    Join Date
    03-07-2012
    Location
    Durban, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    3

    Thumbs up Re: Sorting the alphabetical order with semicolon in each cell.

    Thank mrice!!!! it work!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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