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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement for equivalent value of a range 4
Median continued 12
filter on currency number format 3
Pivot Table with odd results 3
Table Lookup 4
fomula which returns the amount depending on the currency code 3
Another problem - INDIRECT? 3
Passing Currency format from one worksheet to another 2

Top