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