Results 1 to 6 of 6

Extracting Specific Text

Threaded View

  1. #1
    Registered User
    Join Date
    07-06-2011
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    11

    Extracting Specific Text

    I posted a topic similar to this yesterday evening, and received such a fantastic response that I'm back with another question.

    So, I have a column full of cells that look like this

    Three velvet lilies with bead and sequin centers lie 5" long on a 2 1/2" salon clip. Colors: Black, Blush, Winter White <img src="/PDGimages/swatch-calla-lily.jpg" alt="calla lily swatch" />

    Unfortunately, the descriptive text, list of colors and HTML code need to be extracted individually so they can be put in their own column.

    Last night I was taught how to remove the HTML by using a formula which targeted the <'s which open and close the code, which worked great. But now, I need to extract from Colors: through that opening carrot, and once it's in its own column have a way to easily delete it from the existing one.

    Is this possible?
    Last edited by jdh3; 07-11-2011 at 12:52 PM.

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