CONCATENATE

Hi every one
I have concatenated a string. My intention is to use to as a link or
DDE to retrieve some data from outside source.
This string is like that: =PROPHETX|QUOTE!'CU6C2000[DTN:CBOT]?Last'
Is there any one who can tell me how to do it by VB or any other way.
regards
Mason

If the values to be concatenated are in A1, B1 & C1:
=A1&B1&C1

You may insert literals:
=A1&"|"&B1&"!"&C1

HTH
--
AP

"mwlau" <mwlau@discussions.microsoft.com> a écrit dans le message de news:
A1C65035-8123-4719-B2A2-533AC26E79C9@microsoft.com...
> Hi every one
> I have concatenated a string. My intention is to use to as a link or
> DDE to retrieve some data from outside source.
> This string is like that: =PROPHETX|QUOTE!'CU6C2000[DTN:CBOT]?Last'
> Is there any one who can tell me how to do it by VB or any other way.
> regards
> Mason
>

Your string looks like a formula. You can convert a concatenated string into
a real formula:

In B1, put =
In C1, put Sheet2!
In D1, put Z100

In A1, put =B1 & C1 & D1
and A1 will display:
=Sheet2!Z100
but this is only a string.


Enter this tiny macro:

Sub Macro1()
Range("A2").Value = Range("A1").Value
End Sub


and run it and the real formula will be deposited in A2
--
Gary's Student


"mwlau" wrote:

> Hi every one
> I have concatenated a string. My intention is to use to as a link or
> DDE to retrieve some data from outside source.
> This string is like that: =PROPHETX|QUOTE!'CU6C2000[DTN:CBOT]?Last'
> Is there any one who can tell me how to do it by VB or any other way.
> regards
> Mason
>