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