Substract String

Hello,

I would like to know if it is possible to substract a string from a cell in a string from another cell using IF in the way of the screenshot?

result i need to obtain in IF:
center
mount
hill
street
blvd
jeans
shirt
shop

Thx in advance!

So you want to input:

1,2
bakerycenter,bakery
restaurantstreet,restaurant

And output:

1,2,3
bakerycenter,bakery,center
restaurantstreet,restaurant,street

Is that correct?

If so, you can do it like this (I copied the column first, so as not to overwrite the original):

Thanks for the fast answer

The solution work, some extra steps in the way but the result is the one i needed !

Thank you very much !

Have a nice day

1 Like