I have a spreadsheet where I want to search text for multiple search terms, listed in a column on separate tab.
For example, if my search terms were:
Red Sox
Yankees
Blue Jays
Orioles
Rays
and I was searching the following text:
"The Red Sox defeated the Orioles yesterday and remain 3 games up on the Yankees"
the macro should return:
"Red Sox, Orioles, Yankees"
See the attached spreadsheet for a fuller example.
Last edited by LarryLegend; 11-20-2013 at 03:00 PM.
Maybe:
Output sent to Text Column C
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 11-20-2013 at 02:59 PM.
This is in response to your PM. See if it helps.
Please Login or Register to view this content.
Hi John,
Thank you for the reply. It looks like this version will return the search term only if the search term is found exactly AND if it is the only contents of the cell. I need it be exact, but it doesn't need to be the only contents of the cell.
I'm trying to get it so it will return the search term if the term is found anywhere within the cell, but it must be found by itself.
For example, if the term "ING" was on my list:
Search Cell = "IBM is releasing quarterly earnings tomorrow" ; Return should be blank. The original version would pick up the 'ING' from the word 'releasING'
Search Cell = "ING released quarter earnings this morning" ; Return should be 'ING'
Try:
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 11-25-2013 at 01:38 PM.
John,
This works great. Last question, is there a way to adjust it so that it ignores capitalization rules?
Add this line at the Top of your Module
Option Compare Text
Last edited by JOHN H. DAVIS; 11-27-2013 at 12:18 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks