Thread
:
CONCATENATE problem
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
CONCATENATE problem
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett