mporting multiple text files into Excel with corresponding fil
Fair point. If the OP's files include commas within values (not just as a
thousands separator) more work or a different approach is required.
Regards,
Peter T
"Phil Hibbs" wrote in message
...
That will fail if a quoted value contains a comma.
Why ?
I assume that the CSV that the OP has conforms to the Microsoft
format, and that code will convert this:
Phil Hibbs,Programmer,"$100,000"
into this:
[Phil Hibbs] [Programmer] ["$100] [000"]
where [] indicates a cell.
Phil Hibbs.
|