Help

SUBSTITUTE formula

Topic Labels: Formulas
1361 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Arthur
4 - Data Explorer
4 - Data Explorer

Hi,

I have a formulat with prices, like that : € 440,00

I need to convert this value to : 440.00

I’m using the formula SUBSTITUTE({Prix}, "€", "") to remove the €.

But I would like to Also convert the “,” in “.”.

Do you know how can I add a new part to my formula please ?

Thanks ! :slightly_smiling_face:

1 Reply 1
AlliAlosa
10 - Mercury
10 - Mercury

Hi there @Arthur! Welcome to the Airtable community :slightly_smiling_face:

Try this…

TRIM(SUBSTITUTE(SUBSTITUTE({Prix}, "€", ""), ",", "."))

The TRIM() function will remove any white space (looks like there is a space between your currency symbol and number). You could also use…

VALUE(TRIM(SUBSTITUTE(SUBSTITUTE({Prix}, "€", ""), ",", ".")))

To convert the value to an actual number (as opposed to a string) if you’ll need to perform calculations with it later on.

Hope this is helpful!