Skip to main content

SUBSTITUTE formula

  • September 15, 2020
  • 1 reply
  • 20 views
A

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

A
Forum|alt.badge.img+19
  • AlliAlosa
  • Inspiring
  • September 15, 2020

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!

Terms & ConditionsAccessibility statement