Prev: Cannot empty the clipboard
Next: how to calculate histogram from yearly dataset
From: puiuluipui on 3 Jun 2010 03:07
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!
From: Jacob Skaria on 3 Jun 2010 03:13
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!
 | 
Pages: 1
Prev: Cannot empty the clipboard
Next: how to calculate histogram from yearly dataset