How to find & replace a beginning character of a sentence/text if it matches to a particular character?
Same way how to find & replace a last character of a sentence/text if it matches to a particular character?

eg in Cell A1 - (apple (a) 100)
A2 - (orange 50)

Here I need to replace the starting open parenthesis & ending closing parenthesis with none.
A1 - apple (a) 100
A2 - orange 50

How can I do this in excel?
Thanks in advance.

Perhaps =REPLACE(REPLACE(A1,LEN(A1),1,""),1,1,"")

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post