Remove quotation marks in ID

Topic Labels: Formulas
601 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi all! 

In one of my bases quotation marks are added to some of my IDs that are generated through a formula (someone explained to me that it because my titles contain a comma, but I need to keep it).

I would like to remove those quotation marks. I've read and tried a lot of things, but it is not working. 

Here is my formula : 

IF({Nom pour identificateur}, {Nom pour identificateur}, Type) & " " & IF({Début}, {Début pour identificateur}) & " " & Projet
I also add a screenshot of my base.
Thank you very much for the help!
2 Replies 2
11 - Venus
11 - Venus

Hi @Les_Gros_Becs ,

Use the SUBSTITUTE() function to simply replace or delete characters.

Text operators and functions (Formula Field Reference - Overview | Airtable Support)



Unfortunately, it didn't work