Thread: [Solved] concatenate the currency too
View Single Post
 
Old 12-13-2015, 01:04 PM
charlesdh charlesdh is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default
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,))"
Last edited by charlesdh; 12-13-2015 at 01:06 PM. Reason: Wrong code entered
Reply With Quote