Remove parenthesis from data

Is there other information in the cell?

---

»bp

Here is a solution using the same regex function I provided in your prior question.  It finds the number at the end of the cell content and then removes the paren.

EE29141238.xlsm

---

»bp

If A47 only contains the string 77,965.52), you may try Substitute formula to remove the ")" from the cell.

=SUBSTITUTE(A47,")","")

Select allOpen in new window

If A47 contains some other text as well along with the number, you may place this UDF on a standard module like Module1.

Function getNumber(str As String)
With CreateObject("VBScript.RegExp")
    .Global = False
    .Pattern = "\d+\,?\d+\.?\d{2}"
    If .test(str) Then
        getNumber = .Execute(str)(0)
    End If
End With
End Function

Select allOpen in new window

And then use this formula to get the number from the string in A47.

=getNumber(A47)

Select allOpen in new window

GetNumber.xlsm