Results 1 to 3 of 3

Using VBA to find a word in a line of text then return data to the right of it

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    9

    Using VBA to find a word in a line of text then return data to the right of it

    Hello There,

    This is part of a much wider thing but I'm getting tripped up on something.

    In the attached I want the red cell (B7) to look at it's header (B6), then search the large string of gibberish in A1 until it finds it.

    Then once it's found it I want it to return everything to its right that sits between |these symbols|. so the answer would be C_100

    If there is no text between the symbols I want it to enter <ALL> in the cell. As shown in the blue cell.

    If I get it working for the first couple I think I can figure it out for the rest. Please Help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find word in text string and return word adjacent to the left
    By eadamquinn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2014, 03:22 PM
  2. Need to find a word in text and return corresponding value
    By yafirst in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2014, 11:52 AM
  3. [SOLVED] find non-blank cells and return line with only specific text
    By greg19 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2014, 01:43 AM
  4. Replies: 1
    Last Post: 02-01-2013, 01:57 AM
  5. [SOLVED] How to conditionally insert text string into a line after first word using Word 2010
    By staggers47 in forum Word Formatting & General
    Replies: 5
    Last Post: 12-08-2012, 11:07 AM

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