Results 1 to 5 of 5

Sort values within a cell in Excel 2007

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    43

    Sort values within a cell in Excel 2007

    Hi,

    I'm trying to sort some values within a cell, but none of the built in functions available to me seem to do it. Unfortunately I'm not allowed to use the MoreFunc Add-on on our system as I understand that might be able to do it.

    The Cell will contain a series of alphanumeric values, separated by comma and a space:

    ABC001.002, ABC002.019, ABC002.010, ABC001.001 etc

    Is there an easy way to get them to sort automatically so the cell becomes:

    ABC001.001, ABC001.002, ABC002.010, ABC002.019

    This only needs to happen in one column of my spreadsheet (Column P) and work dynamically across 1700 rows so far, so each time colum P of a row gets updated.

    Any ideas would be gratefully accepted.

    Thanks

    Richard
    Last edited by asparak; 07-23-2012 at 06:33 AM.

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