Link to home
Create AccountLog in
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
Avatar of Bill Prew
Bill Prew

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


»bp
Avatar of finnstone

ASKER

here it is
Book3.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
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
thanks. wow lots of points
There are 124 Experts with more points than I. The leader is Guy Hengel with 41 million!