• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find a list of words in a cell

markdeuel

New Member
@Sir I appreciate your help. It looks like the formula almost work but if you notice the first three columns did not produce a name in the yellow fields. I figure this is because the code it's trying to retrieve is the last thing in the cell and thus, not separated by a comma.


@Narayan - This worked! I wish I knew why it worked, but it did.


Thanks to both of you for your help and patience with me. It has been awesome.


Thanks so much!


Mark
 

SirJB7

Excel Rōnin
Hi, markdeuel!


There were a couple of:

&","

after:

$A2

that were missing.


I apologize, it's yet fixed. Please download again the updated file from same previous link.


Regards!
 

markdeuel

New Member
Will do Sir, and again, I appreciate your help.


I'll download that file soon, but now I should actually do some work!


Thanks again!!


Mark
 

SirJB7

Excel Rōnin
Hi, markdeuel!

Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!
 

Montrey

Member
Just want to say this is a really cool formula to extract stuff from text if you have a list of what you want to find.


This is in reference to the formula posted by Chandoo and the preceding posters.
 
Top