Results 1 to 4 of 4

pull out text between 2 symbols in a string within a cell

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2008
    MS-Off Ver
    Excel 2003
    Posts
    30

    pull out text between 2 symbols in a string within a cell

    I have a column of cells that contain a long string of characters....I need to pull out text from this string and put it in subsequent columns. The symbol I am concerned with is >> For example.

    If this string is in the first cell in column A:
    >>abcd>>defgh>>ijkl

    I would want a formula to return abcd in column b, defgh in column C, and ijkl in column d

    >>this is a test>>make it work

    in this example I would want "this is a test" returned in column B, and "make it work" ruturned in column C

    >>frustrating

    In this example, I would want "frustrating" returned in column B


    any ideas?

    Thanks in advance!
    Last edited by jasonanthony; 02-02-2009 at 06:18 PM. Reason: Solved

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