Find & replace a character in a particuler position
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.
|