+ Reply to Thread
Results 1 to 3 of 3

Extract data from text string

  1. #1
    Forum Contributor
    Join Date
    04-30-2011
    Location
    wirral,england
    MS-Off Ver
    Excel 2010
    Posts
    144

    Extract data from text string

    Hello All
    I have a spreadsheet with a number of text strings in Col A and would to extract data from them and put it in a number of other Columns as follows
    1.Time at the begining of the string - insert in Col E
    2.If text contains "Hurdle"- Col Q insert "HDL"
    If text contains "Chase"- Col Q insert "CHS"
    If text contains "National Hunt Flat"- Col Q insert "NHF"
    If text contains none of the above - Col Q insert "FLT"
    3.If text contains "Handicap" or "H“cap" Col R insert "HCP"
    If text does not contain "Handicap" Col R insert "STKS"
    4. If text contains "Novice"- Col BI insert "NOV"
    If text contains "Maiden"- Col BI insert "MDN"
    If text contains none of the above - Col BI insert "NOT"
    5. Class number insert to Col O
    6. Distance (found at the end of the text) insert to Col N
    7. Winner amount without the comma or £ sign to Col M
    (if possible rounded to 500 using the MROUND function)

    Col A will then be removed and the days date inserted.
    The data will be used every day so a macro would be ideal,I have attached a spreadsheet showing the required data,which i hope will explain it better.
    Many thanks for help given.
    Attached Files Attached Files
    Last edited by bigband1; 11-24-2011 at 04:59 AM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Extract data from text string

    Hi

    See how this goes.

    Please Login or Register  to view this content.
    rylo

  3. #3
    Forum Contributor
    Join Date
    04-30-2011
    Location
    wirral,england
    MS-Off Ver
    Excel 2010
    Posts
    144

    Re: Extract data from text string

    Spot on,brilliant.In AUS right now on hol,great country,Thanks again.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1