Substitute word by list

**vasc** · 02-04-2019, 11:05 AM

My friend,

how put a black list in next excel file?

column I and N contain prohibited word

all formula is in the file for function with two word, but increasing number of word increasing the number of column.
ideas?

thanks again

**Bo_Ry** · 02-04-2019, 11:51 AM

Please try

T9 Key-in search

R9
=TEXT(D9,"hh:mm-")&SUBSTITUTE(SUBSTITUTE(C9,IFERROR(LOOKUP(1,-SEARCH($T$9:$T$17,C9),$T$9:$T$17),""),""),",","")

**vasc** · 02-05-2019, 02:50 AM

thank`s Bo_Ry workkkk....

**Bo_Ry** · 02-05-2019, 07:26 AM

Happy to help

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Substitute word by list

LinkBack

Thread Tools

Rate This Thread

Display

Substitute word by list

Re: Substitute word by list

Re: Substitute word by list

Re: Substitute word by list

Thread Information

Users Browsing this Thread

Similar Threads

VBA script to substitute text from an excel sheet into various word docs by filepath

Substitute using a named list

[SOLVED] Is there another way to write INDEX(INDIRECT(SUBSTITUTE()),MATCH(OFFSET(SUBSTITUTE()))?

[SOLVED] Need a formula to find and substitute a word in a text if a condition is met...

[SOLVED] How can I replace a word from a sentence in a cell & substitute word from another cell

SUBSTITUTE word in multiple cells

How to Substitute a Singular/Plural word to nothing in an Alphanumeric Text..?

Bookmarks

Bookmarks

Posting Permissions