troubleshooting Question

Help to make a Boolean Search string from an Excel Row

Avatar of Doug Haselwood
Doug HaselwoodFlag for Australia asked on
* Excel TableMicrosoft Excel* booleanMicrosoft Office
3 Comments1 Solution20 ViewsLast Modified:
Please see sample - I have a spreadsheet attained from a marketing database which I want to create a Boolean search per ROW for.

Sample.xlsx

As you can see - the sample data will have varying data in it and needs to have the format (From A2 example)

 
IDName1Name2Name3Name4Name5Name6Name7Contact Number1Contact Number2Contact Number4Contact Number5Email1Email2Email3Email4Address1Address2Address3Address4Address5Address6Address7Address8Address9Address10Address11Address12Address13Address14
123245678JedBush




088490033


jed@gmail.com


123 Fake St Springfield12345WAUSAEarthMilkyWayGalaxyNearAndromeda



It needs to look like:

12345678 OR "Jed Bush" OR 088490033 OR jed@gmail.com OR "123 Fake St Springfield WA 12345 USA Earth Milky Way Galaxy Near Andromeda"

So names and addresses need to be concatenated and wrapped in quotes however contact numbers and email addresses need to be separated by an 'OR' statement

 
876543213BarbaraValentineBush



095747773234890230

Babs@gmail.combarbara@hotmail.com

321 Varsity DriveWilmington12345VA










So this would look like:

876543213 OR "Barbara Valentine Bush" OR 095747773 OR 234890230 OR babs@gmail.com OR barbara@hotmail.com OR "321 Varsity Drive Wilmington 12345 VA"

Thanks for your help,
ASKER CERTIFIED SOLUTION
Gary Benjamin
Business Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros