Avatar of finnstone
finnstone
 asked on

delete words from cellls

i have a blacklist of words i need to be deleted, 400 words

in another book, col A, I need to delete a word from a list in a cell where those words in are the cells. it is not a simple vlookup since col A format is lists of words sepeareted by commas

so
VBA

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Bill Prew

If you could upload a sample workbook that would be helpful.


»bp
finnstone

ASKER
here it is
Book3.xlsx
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

You’re welcome and I’m glad I was able to help.

And thank you for my 5 millionth point!

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
finnstone

ASKER
thanks. wow lots of points
Martin Liss

There are 124 Experts with more points than I. The leader is Guy Hengel with 41 million!