CONCATENATE

M

mwlau

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
 
A

Ardus Petus

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

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

HTH
 
G

Gary''s Student

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
 
Top