ironhide1975
Programmer
How does one export an excel file to a comma delimited text file?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export Excel to Comma Delimited Txt file 1
- Thread starter ironhide1975
- Start date
- Status
mscallisto
Technical User
file > Save As > choose file type as CSV from the DropDownListBox
What if you have commas in a cell?
Just askin'.
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.
Just askin'.
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.
AnotherHiggins
Technical User
Then I'd suggest using tab separated instead.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
-
1
- #5
JockMullin
MIS
Hi, Phil
If a cell contains commas then Excel will automatically enclose the contents in double quotes.
This convention is however not universally supported, in particular many Unix based programs don't seem to handle it properly and will still see the embedded and misalign fields as a result.
Jock
If a cell contains commas then Excel will automatically enclose the contents in double quotes.
This convention is however not universally supported, in particular many Unix based programs don't seem to handle it properly and will still see the embedded and misalign fields as a result.
Jock
- Status
Similar threads
- Locked
- Question
- Locked
- Question