Forum Discussion

JOGINDER SINGH's avatar
JOGINDER SINGH
Tin Contributor
Mar 15, 2023

Removing special character and adding value

Hellow all

 

I have a query as below; -

 

I have value "5544.21+0+0%+Rs+3000.21" in Column A. I want to add only the value with each other containing 5544.21 and 3000.21 and want to remove other special characters like "+", "0%" & "Rs" etc.

 

Give excel function. I don't want to use any readymade too or wizard to separate this value.

3 Replies

    • JOGINDER SINGH's avatar
      JOGINDER SINGH
      Tin Contributor
      Thanks , this is working in Office 365 or Excel Online. But not working in Office excel 2021. Can You help please by function.