Don

Looks like I've hit a dead end, that didn't work either, I'm going to try a
VB solution.

Thanks for your help

Mark

"Don Guillett" wrote:

Didn't know about that, so try
=right(B3,len(b3)-1)&B4&"("&B5&")"


--
Don Guillett
SalesAid Software

"Mark Dullingham" wrote in
message ...
Don
Thanks for your reply, unfortunately it didn't solve the promblem. The
'='
at the begining of the DDE link is still causing the value to be returned
as
#NAME?

Mark
"Don Guillett" wrote:

try
=B3&B4&B5
or without typing the ( )
=B3&B4&"("&B5&")"
--
Don Guillett
SalesAid Software

"Mark Dullingham" wrote in
message ...
I am trying to constuct a table of DDE links to be referenceby offset
amd
match funtions on another sheet. There are hundreds of these links, so
tomake
entering them a bit easier I'm trying to use CONCATENATE to help reduce
the
time.

The liks look like this

=the962|IQVALUE!'L14O011S1(V)'

=the962|IQVALUE!'L14O011 this bit stays the same

But S1 will change and so will the text inside the brackets.

if I place =the962|IQVALUE!'L14O011 in one cell, S1 in another and
(V)'
in
another and use =CONCATENATE(Cell1, Cell2, Cell3) the = in cell 1 makes
it
return "Cell1" in the CONCATENATE result.

Is there a way around this?