C
Colin Hayes
You only need to use a dummy cell if you are concatenating with html
that already has "" in the text and will throw out excel, Otherwise it's
just an odd way round an easy problem as ," ", is the correct answer
easy spaces and more.
Concatenating with HTML...
You cannot input =CONCATENATE(A1," <a ref="Text Here></a> ",B1)
On a different sheet you would put you repeated text, and the formula
would be.
=CONCATENATE(A1","WORKSHEET3!A$1",B1).
This is the only circumstance where you would need to do this, our
entire eBay auction page is set up like this and concatenated into the
database in the same way before it goes to eBay.
Hi,
Rather than use dummy cells which could get messy just type in
whatever you
want between the cell references in speech marks, so the formula would
be:-
=concatenate(a1&" whatever you want here. "&b1&" text2.")
... So if cell a1 had Beatles & cell b1 had Revolver the result would
read:-
Beatles whatever you want here. Revolver text2.
Hope this helps (& makes sense!)
----- Original Message -----
that already has "" in the text and will throw out excel, Otherwise it's
just an odd way round an easy problem as ," ", is the correct answer
easy spaces and more.
Concatenating with HTML...
You cannot input =CONCATENATE(A1," <a ref="Text Here></a> ",B1)
On a different sheet you would put you repeated text, and the formula
would be.
=CONCATENATE(A1","WORKSHEET3!A$1",B1).
This is the only circumstance where you would need to do this, our
entire eBay auction page is set up like this and concatenated into the
database in the same way before it goes to eBay.
Hi,
Rather than use dummy cells which could get messy just type in
whatever you
want between the cell references in speech marks, so the formula would
be:-
=concatenate(a1&" whatever you want here. "&b1&" text2.")
... So if cell a1 had Beatles & cell b1 had Revolver the result would
read:-
Beatles whatever you want here. Revolver text2.
Hope this helps (& makes sense!)
----- Original Message -----