VBA to keep format when concatenating

[isasa74]

no problem Sir! and thanks a lot for helping me!

[isasa74]

HI SamT

I've eventually had the concatenation with the correct currency using the below formula :

=IF(ISBLANK(A2),"""",CONCATENATE(A2,"" "",B2,"" "",C2,"" "",""Price"","" "",IF(CELL(""format"",D2)=""C2"",TEXT(D2,""€ #.##0,00""),TEXT(D2,""$ #.##0,00"")),"" "",""Freight"","" "",IF(CELL(""format"",E2)="",2"",TEXT(E1,""€ #.##00""),TEXT(E2,""$ #.##0,00"")),"" "",""Duties"","" "",F2))

or alternatively and maybe more simply :


=IF(ISBLANK(A2),"",CONCATENATE(A2," ",B2," ",C2," ","Price"," ",TEXT(D2,V_aluta(D2)&" #.##0,00")," ","Freight"," ",TEXT(E2,V_aluta(E2)&" #.##0,00")," ","Duties"," ",F2))

I would like to send you the THANKS EMAIL because even we didn't sort out the concatenation issue together I've leant a lot from your posts
Please let me know where to send the email and if you want the Dutch EURO coin send me a physical address where to send it

Thanks again and enjoy!