Help

Substitute

Topic Labels: Formulas
602 0
cancel
Showing results for 
Search instead for 
Did you mean: 
karimM
4 - Data Explorer
4 - Data Explorer

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

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")
0 Replies 0