Wonderful -it works perfectly! Thank you once again!
One last question - how can I make it not make up plural forms ie: only Power, not Powers; or organ, not organization; or just US rather than USSC?
Many thanks!
Wonderful -it works perfectly! Thank you once again!
One last question - how can I make it not make up plural forms ie: only Power, not Powers; or organ, not organization; or just US rather than USSC?
Many thanks!
Do you mean you don't want it to pick up Power when the sentence contains Powers?
If so, try:
CSE confirmed![]()
=SUBSTITUTE(SUBSTITUTE(TRIM(ACONCAT(IF(ISNUMBER(FIND(" "&KeyWords&" "," "&SUBSTITUTE(SUBSTITUTE(B2,".",""),",","")&" ")),SUBSTITUTE(KeyWords," ","^^"),"")," "))," ",", "),"^^"," ")
But note, that if you have words that have a symbol next to them like for example in this sentence: I am the best (President) of all time. Then it would not pick up President because it has a bracket before and/or after... I have used SUBSTITUTE functions to replace periods and commas, you can add more for the brackets, but there could be other symbols, like semi colons or colons, or exclamation points, or question marks, etc....
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks