Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting Excel data into semicolon delimited text file
I have no problem converting a txt file into Excel but I want to do it the
other way around and the request is to have it semicolon delimited (not tab delimited which is easy enough). In other words, .xls to .txt with the character of choice. |
#2
|
|||
|
|||
I believe I have my answer; save as .csv, open in Notepad. Since I changed
the default "list separator" to a semicolon, it already used that character. Thanks anyhow. "danmcgov" wrote: I have no problem converting a txt file into Excel but I want to do it the other way around and the request is to have it semicolon delimited (not tab delimited which is easy enough). In other words, .xls to .txt with the character of choice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Layout/Formatting problems of Data Queries in Excel? | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |