Results 1 to 13 of 13

rearranging order of text string inside a cell

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2009
    Location
    NJ, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    rearranging order of text string inside a cell

    I need help rearragning text on excel. I believe Macro will be needed to solve this problem so if anyone can help me out, it will be a big help. Thank you.

    Example 1:
    I need to rearrange
    "trace Silt, cm SAND, some- f Gravel" into
    "cm SAND, some- f Gravel, trace Silt"

    Example 2:
    I need to rearrange
    "some+ Silt, f SAND, trace- f Gravel" into
    "f SAND, some+ Silt, trace- f Gravel"

    There are many different cases for this problem. So if there is a way for the computer to recognize the Capitalized word and move it to the front and rest should be arange in order listed below.

    Order
    and+
    and
    and-
    some+
    some
    some-
    little+
    little
    little-
    trace+
    trace
    trace-

    each term is seprarated by commas.
    For example
    f SAND, some+ Silt, trace- f Gravel
    each color represent one complete sentence. and the order for them should be capitalized funciton first, then the follow the order provided above.
    Last edited by Milan Limbachia; 04-09-2009 at 04:42 PM.

Thread Information

Users Browsing this Thread

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

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