0

I have a column named Amount in Single line of Text

It has values like 300$

Now I want to get the value of it except for the $ symbol

I am trying INT([Amount])

But I would also need decimal values, so what is the best way to get just the numbers without $ from the Amount Column and assign it to calculated column?

Vignesh Subramanian
  • 3,276
  • 6
  • 50
  • 98

2 Answers2

1

You can use below formula

=LEFT([Amount],INT(FIND("$",[Amount])-1))

Ref :See Here

SharePointMan
  • 3,364
  • 5
  • 33
  • 51
0

Since some entries had $ and some didn't have I went with the below formula

=IF(ISNUMBER(FIND("$",[Amount])), RIGHT([Amount], LEN([Amount])-1) , [Amount])

This will check if it has $ in the beginning, and then return all items from right except $

Vignesh Subramanian
  • 3,276
  • 6
  • 50
  • 98