mael
1
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!
Admin
2
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?
Admin
3
If so, you can do it like this (I copied the column first, so as not to overwrite the original):
mael
4
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