+ Reply to Thread
Results 1 to 3 of 3

Sorting the alphabetical order with semicolon in each cell.

  1. 03-07-2012, 07:52 AM #1
    spiderkzn
    spiderkzn is offline
    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
    Reply With QuoteRegister To Reply
  2. 03-07-2012, 09:05 AM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    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
    Reply With QuoteRegister To Reply
  3. 03-07-2012, 09:55 AM #3
    spiderkzn
    spiderkzn is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1