Skip to main content

Hello you!

I'm looking to remove 2 characters of fields, from the right of the cell. I have a list of prices, like that, no currency :

15701
9740
1549

I'm looking to get this :

157 Є
97 Є
15 Є

The deleted numbers are the cents 🙂

Cheers! 

Hi @Julien_Etoke,

Please give this a try:

LEFT({your_field}, LEN({your_field}) - 2)

https://support.airtable.com/docs/extracting-text-from-a-field

-Stephen

 

 


Hello, Julien
There are two ways to do this.
Either as a String or Numeric.

In case of a number (choose the correct amount)

FLOOR({Cent Euro}/100,1)
ROUND({Cent Euro}/100,1)
ROUNDUP({Cent Euro}/100,1)
ROUNDDOWN({Cent Euro}/100,1)

In case of a string

VALUE(LEFT(CONCATENATE({Cent Euro}),LEN(CONCATENATE({Cent Euro}))-2))

 


Hi @Julien_Etoke,

Please give this a try:

LEFT({your_field}, LEN({your_field}) - 2)

https://support.airtable.com/docs/extracting-text-from-a-field

-Stephen

 

 


Hello! It works, thanks a lot 🙂


Hello, Julien
There are two ways to do this.
Either as a String or Numeric.

In case of a number (choose the correct amount)

FLOOR({Cent Euro}/100,1)
ROUND({Cent Euro}/100,1)
ROUNDUP({Cent Euro}/100,1)
ROUNDDOWN({Cent Euro}/100,1)

In case of a string

VALUE(LEFT(CONCATENATE({Cent Euro}),LEN(CONCATENATE({Cent Euro}))-2))

 


Hello Sho!

Thank you for this very complete answer 🙂


Reply