How to concatenate text and currency values

[loosefred]

Hi all,

I'm looking to create a function on excel to help with simplifying the process of making Google Ads for a number of clients, by concatenating a string of words to form lines of ads. For example,

Word 1	Word 2	Word 3	Word 4	Word 5	Word 6	Word 7	Word 8	Word 9	AD
Used	Vans	in	Darlington						Used Vans in Darlington
Hundreds	of	Used	Vans	Available					Hundreds of Used Vans Available
Call	Now	to	Find	Out	More				Call Now to Find Out More
usedvans.com	darlington								usedvans.com/darlington

<tbody>
</tbody>

The chain of words create the text of each line of ads on the right, with formula as:

=CONCATENATE(IF(LEN(D3)>0,D3&" ",""),IF(LEN(E3)>0,E3&" ",""),IF(LEN(F3)>0,F3&" ",""),IF(LEN(G3)>0,G3&" ",""),IF(LEN(H3)>0,H3&" ",""),IF(LEN(I3)>0,I3&" ",""),IF(LEN(J3)>0,J3&" ",""),IF(LEN(K3)>0,K3&" ",""),IF(LEN(L3)>0,L3,""))

My problem is that I would like to include prices within this ad text, however the currency formatting is not shown in the ads. For example:

Word 1	Word 2	Word 3	Word 4	Word 5	Word 6	Word 7	Word 8	Word 9	AD
Used	Vans	in	Darlington						Used Vans in Darlington
Prices	from	Only	£4,995						Prices from Only 4995
Call	Now	to	Find	Out	More				Call Now to Find Out More
usedvans.com	darlington								usedvans.com/darlington

<tbody>
</tbody>

In the ads, the £x,xxx formatting isn't transferred into the ad on the right. Is there any way that this could be fixed at all so that the ad would include this?

Thanks very much in advance!

 

[loosefred]

Hi all,

I'm looking to create a function on excel to help with simplifying the process of making Google Ads for a number of clients, by concatenating a string of words to form lines of ads. For example,

Word 1	Word 2	Word 3	Word 4	Word 5	Word 6	Word 7	Word 8	Word 9	AD
Used	Vans	in	Darlington						Used Vans in Darlington
Hundreds	of	Used	Vans	Available					Hundreds of Used Vans Available
Call	Now	to	Find	Out	More				Call Now to Find Out More
usedvans.com	darlington								usedvans.com/darlington

<tbody>
</tbody>

The chain of words create the text of each line of ads on the right, with formula as:

=CONCATENATE(IF(LEN(D3)>0,D3&" ",""),IF(LEN(E3)>0,E3&" ",""),IF(LEN(F3)>0,F3&" ",""),IF(LEN(G3)>0,G3&" ",""),IF(LEN(H3)>0,H3&" ",""),IF(LEN(I3)>0,I3&" ",""),IF(LEN(J3)>0,J3&" ",""),IF(LEN(K3)>0,K3&" ",""),IF(LEN(L3)>0,L3,""))

My problem is that I would like to include prices within this ad text, however the currency formatting is not shown in the ads. For example:

Word 1	Word 2	Word 3	Word 4	Word 5	Word 6	Word 7	Word 8	Word 9	AD
Used	Vans	in	Darlington						Used Vans in Darlington
Prices	from	Only	£4,995						Prices from Only 4995
Call	Now	to	Find	Out	More				Call Now to Find Out More
usedvans.com	darlington								usedvans.com/darlington

<tbody>
</tbody>

In the ads, the £x,xxx formatting isn't transferred into the ad on the right. Is there any way that this could be fixed at all so that the ad would include this?

Thanks very much in advance!

Figured it out - I have to apostrophise the before the start of currency. Should have known.