13 Replies Latest reply: Nov 13, 2015 10:05 AM by Srikanth P RSS

    how to remove $ in money column?

    Prashanth Reddy Nasi

      Hi all,

       

      I have Price coulmn in excel sheetas below:

      I used  trim(replace(Price),'$','') as Price1

       

      Product              Price              My output          expected o/p

      A                        $10                    10                         10

      B                        $20                    20                          20

      C                        $15                    15                         15

      D                        $-10                    10                        -10

      E                        $-5                      5                          -5

      F                        $25                      25                        25

      G                        $-30                    30                        -30

       

      Thank you.