ExcelBanter - Excel macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel macro (https://www.excelbanter.com/excel-discussion-misc-queries/265132-excel-macro.html)

puiuluipui

Excel macro

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!

Jacob Skaria

Excel macro

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!

All times are GMT +1. The time now is 05:07 PM.