I would like to ask about replacing multiple possible characters in excel. I have some cells containing coordinates like:

(37.286.866, 16.826.515)

(36.491.603, 17.624.765)

(37.297.949, 16.951.373)

I would like to get their value in a new cell without the parentheses and (if possible) the space between like:

37.286.866,16.826.515

To make it clear in a cell both coordinates are included. For example *A1* cell contains `(37.286.866, 16.826.515)`

I tried something like (with the intention of using another embedded `SUBSTITUTE`

after that) but is does not seem to work:

```
=SUBSTITUTE(A1;"(";"-")
```

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.