View Single Post
 
Old 07-27-2016, 11:05 PM
klllmmm klllmmm is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2015
Posts: 4
klllmmm is on a distinguished road
Default 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.
Reply With Quote