Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Remove from position

Topic Labels: Formulas
Solved
Jump to Solution
1600 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 🙂