I would like to ask about replacing multiple possible characters in excel. I have some cells containing coordinates like:
I would like to get their value in a new cell without the parentheses and (if possible) the space between like:
To make it clear in a cell both coordinates are included. For example A1 cell contains
I tried something like (with the intention of using another embedded
SUBSTITUTE after that) but is does not seem to work:
Although there is no error just a blank cell.
Any idea how can I achieve this?
I am not interested in VB solutions if possible. Just an in-cell solution. The functionality I am looking (if this makes it any clearer) is similar to the regex
[()] where any of the previous could be replaced.
I am using MS office 2010.