Forum Discussion
James Morgan
Dec 15, 2016Copper Contributor
completing statements in Excel
I have built an excel sheet that creates commands that I need to run in my software to make updates. I have cells 1 that contain information (column b) that is updated according to the job. ...
Lutz Gebhardt
Dec 16, 2016Copper Contributor
Hallo James,
just convert your date into text.
="my neighbor "&B1&" moved into "&B2&", "&B3&" on "&TEXT(B4,"MM/DD/YY")&""
Regards, Lutz