One way...to return the text

Dim strData As String
strData = "Invoice currency (USD)ind)"
MsgBox Split(Split(strData, "(")(1), ")")(0)

--
Jacob (MVP - Excel)


"puiuluipui" wrote:

Hi, i need a macro to copy from one cell the text below and to paste only the
contenet of the parenthesis.

Invoice currency (USD):

I need to paste only USD. The currency can contain "USD, EUR' CHF,...etc"
Can this be done?
Thanks!