Remove from position

Topic Labels: Formulas
Solved
Jump to Solution
849 4
cancel
Showing results for
Search instead for
Did you mean:
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
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

4 Replies 4
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

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))`

6 - Interface Innovator

Hello! It works, thanks a lot 🙂

6 - Interface Innovator

Hello Sho!

Thank you for this very complete answer 🙂