Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-17-2019, 08:48 AM
transactions transactions is offline Windows 7 64bit Office 2013
Novice
 
Join Date: May 2019
Posts: 1
transactions is on a distinguished road
Default Search Multiple Strings and if Present get single word as output

Hey I am thinking about creating an excel which would analyse a press release and would search with different strings and if the string is present than it would give a single word as out put



example - if the terms - "Board" and " Approved" are present in A1 (Press release) then in A2 "Board Approval" should come. If terms "Legal" and "advisor" are present in the A1 (Press Release) then in A3 "Legal Advisor" should come. I have close to 20 such combinations (some with 2 words, some with 4 or more) and there output if present.

can some one please help me
Reply With Quote
  #2  
Old 05-17-2019, 11:18 AM
Alansidman's Avatar
Alansidman Alansidman is offline Windows 10 Office 2019
Novice
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 15
Alansidman is on a distinguished road
Default

You can do this with VBA and use the Case Select functions. You will need to identity each of the combinations and the expected result for each of the combos. If you would like to upload a sample (representative) workbook with these scenarios, I am sure that a viable solution can be supplied. Without seeing some actual information, it is difficult to prescribe a solution.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple part presentation - how to present only a subset of slides + a conclusion ? dchabaut PowerPoint 3 04-07-2015 10:16 AM
how do I search the content of excel files for text strings soren Excel 2 03-19-2015 09:42 AM
Search Multiple strings and create new word file subodhgupta Word 4 05-22-2014 03:34 AM
Search Multiple strings and create new word sheet subodhgupta Word Tables 1 05-20-2014 08:09 AM
Search with multiple strings silverspr Excel 7 03-03-2013 04:45 PM


All times are GMT -7. The time now is 10:07 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft