Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Remove from position

Topic Labels: Formulas
Solved
Jump to Solution
1309 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Julien_Etoke
6 - Interface Innovator
6 - Interface Innovator

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! 

1 Solution

Accepted Solutions
Stephen_Orr1
10 - Mercury
10 - Mercury

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

 

 

See Solution in Thread

4 Replies 4
Stephen_Orr1
10 - Mercury
10 - Mercury

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

 

 

Sho
11 - Venus
11 - Venus

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! It works, thanks a lot 🙂

Hello Sho!

Thank you for this very complete answer 🙂