Replace content of one column repeated in another

Hello All,

I do some manipulation with address data and need to achieve the following.

I have 2 columns. The text in column 1 represents (always) a part of the text in column 2 next to it.

I want to delete this (and only this) part in column 2.

The respective replacement shall always happen in the same row, so e.g. the text in column 1 and 2 always are in the same row.

An example:

Column 1                  Column 2                              desired result in column 2 after replacement

Test street               Test street 2                                                       2

City centre             city centre test place                                     test place

Test lane                  Test lane 121a                                                 121a

Answered here: