Excel: Remove part of cell (String) based on another cell (String)

I have two columns/cells that look like this:

Column A Column B
Word123 Word1 Word12 Word123 Word1234

My question:
How can I remove the "Word123" (value of Column A) inside Column B so that the value of Column B looks like this:
Word1 Word12 Word1234

Note that in Column B there is always one space character betweens these values and I have a lot of rows that need this kind of processing.

I have tried using the SUBSTITUTE Function but that doesnt seem to do the trick

>Solution :

Try the following formula-


enter image description here

Leave a Reply