So you'll have to evaluate if that requires handling such as with IF logic. One potential issue is if some records are shorter than others, producing data like 384 38 'Foo' If the Decimal Separator is a comma (,) then the CSV separator will be a semicolon.
may give you some useful ideas, or ask here - it's not complex. You can build the output file in VBA instead of using the Sheet4 above. en-us Q288839Īt any rate, to achieve what you want, you can go to a different worksheet and build your own semicolon delimited data with the ampersand (&) concatenation operator.Ī1=Sheet1!A1& ' ' &Sheet1!B1& ' ' &Sheet1!C1& ' ' &Sheet1!D1& ' ' &Sheet1!E1& ' ' &Sheet1!F1& ' ' &Sheet1!G1& ' ' &Sheet1!H1& ' ' &Sheet1!I1& ' ' &Sheet1!J1& ' ' &Sheet1!K1& ' ' &Sheet1!L1Īnd copy that down column A. setting, CSV means 'Comma Separated Value.' I would have thought that European operating systems would make the substitution you want, but see this.
