Hi,
I am trying to find how to remove brackets that appears in cells according to the example below:
Cell 1: shai(alpha)
Cell 2: shai(alphabeta)
Cell 3: Myname(shaibnnns)
What I would like is to remove all the characters appear in the brackets in these cells. Note the position of the characters vary from cell to cell and I need to remove all the characters as appear in the brackets, so the reults shoul look like:
Cell 1: Shai
Cell 2: Shai
Cell 3: Myname
Any idea which formula can I use? It wouldn't be probably 'RIGHT', 'LEFT' or 'TRIM'...
Thanks,
Shai
Bookmarks