Help improving a VBA that Find And Replaces Multiple Text Strings Within A Text String

[tkew]

So I have the following VBA which allows me to use the formula =REPLACETEXTS(A2,$A$6:$A$9,$B$6:$B$9) to find and replace words in text strings with words in a list.

The issue is that it is case sensitive and if the word i'm looking for eg "apple" doesn't have a space between it and the previous word eg "NOapple"

eventually I need to use this for find replace list of over 1000 names!

I've attached an example and highlighted where it goes wrong in red

[millz]

Added this line right above your code it ignores cases:

Please Login or Register  to view this content.

If you want it to also replace "Johnsmith" for "John smith"->"[Test 2]", you may need a different approach. Maybe removing spaces.

[tkew]

I am looking to replace "John Smith" NOT "Johnsmith".

The issues are is the name appears as "john smith" (No capitals) and "other nameJohn Smith" ( no space before John)

[tkew]

Not sure I understand what you have changed?

[millz]

I didn't change anything, just add a line above your code.

https://docs.microsoft.com/en-us/dot...pare-statement

[tkew]

sorry I see that now. Will this now also ignore accents?!