LinkBack URL
About LinkBacks
Hi Katie and welcome to the forum,
Something like this perhaps? First two works only looked for in this formula.
=CONCATENATE(IF(ISNUMBER(SEARCH("missing",$D2)),"Missing",""),IF(ISNUMBER(SEARCH("New",$D2))," New",""))
Hi Katie and welcome to the forum,
Something like this perhaps? First two works only looked for in this formula.
=CONCATENATE(IF(ISNUMBER(SEARCH("missing",$D2)),"Missing",""),IF(ISNUMBER(SEARCH("New",$D2))," New",""))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Re: How to extract multiple words from one cell
oh my gosh!! Do you have any idea how much time i wasted today trying to figure this out? LOL
Thank you soooo much!!
I'm sure you will be hearing from me again, Excel formulas are so confusing sometimes.
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks