Forum Discussion
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
- Thanks , this is working in Office 365 or Excel Online. But not working in Office excel 2021. Can You help please by function.
Try
=TRIM(LEFT(SUBSTITUTE(A1,"+",REPT(" ",255)),255))+TRIM(RIGHT(SUBSTITUTE(A1,"+",REPT(" ",255)),255))
