concatenate the currency too

isasa74 · #7 12-13-2015, 01:22 PM

Quote:

Originally Posted by charlesdh

Hi,

Here's a line of code that worked for the "$". You can reformat the rest of the line for the other symbol. I entered a "?" for it.

Code:

         WkStg = "=IF(ISBLANK(A2),"""",CONCATENATE(A2,""  "",B2,""  "",C2,""  "",""Price"",""  "",""$"",D2,""  "",""Freight"","" "",""?"",E2,""  "",""Duties"","" "",F2,))"

Hi charlesdh,

thanks for your help you are very kind, however I think that way I will always have the $ no matter what is the real currency that I have in column D & E.
The currency for both columns (Price and Freight) it is not constant, it changes and can be randomly either USD or EUR.
So the code should be dynamical and " capable" to read the format in D&E and reporting it accordingly in the concatenation.

thanks again

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)	SoonerLater	Mail Merge	1	09-30-2015 05:40 PM
how to concatenate text box on new slide	wichitawx	PowerPoint	5	05-19-2015 05:17 AM
Concatenate with @ symbol	anickles	Excel	2	02-06-2015 09:39 AM
Concatenate if in descending order	pgeorgilas	Excel Programming	2	12-10-2014 01:35 AM
If, move and concatenate in VBA	devcon	Excel Programming	0	07-04-2011 12:44 AM