Hi Team
I need to know what formula I can use to subtitute the culumn at the left, this is a multi select culumn to the culumn a specific name. It seems possible to have severall subtitute fonction in a row but my formula doesnt work.
Any suggestions?
![karimM_0-1684338590971.png karimM_0-1684338590971.png](/t5/image/serverpage/image-id/27660iD95EC7F836EC03B3/image-size/medium?v=v2&px=400)
Here what I tried to test
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Annonce}"Lovely Clichy Home - Mairie de Clichy / Levallois","Xavier Clichy"), "Studio au pied du Sacré-Coeur","Feutrier"),
"Magnificent duplex in Montrouge near Metro Barbara","Barbara")