Excel macro

P

puiuluipui

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!
 
J

Jacob Skaria

One way...to return the text

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