Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

SUBSTITUTE formula

Topic Labels: Formulas
403 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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!