| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert excel to text file with no tabs
Hi,
I need to convert an excel file to a text file which is not tab delimited. Does anyone know how to do this? If I "save as" a text file, whatever option I choose, there are tabs between the cells. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert excel to text file with no tabs
Other text options are space delimited (.prn) or comma separated (.csv).
-- David Biddulph "naomi" wrote in message ... Hi, I need to convert an excel file to a text file which is not tab delimited. Does anyone know how to do this? If I "save as" a text file, whatever option I choose, there are tabs between the cells. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert excel to text file with no tabs
Thanks - but it still isn't what i need. It puts 3 or 4 spaces between the
contents of each cell. I need a single space. Apparently it can be done, but no-one sems to know how. "David Biddulph" wrote: Other text options are space delimited (.prn) or comma separated (.csv). -- David Biddulph "naomi" wrote in message ... Hi, I need to convert an excel file to a text file which is not tab delimited. Does anyone know how to do this? If I "save as" a text file, whatever option I choose, there are tabs between the cells. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert excel to text file with no tabs
It can be done.........many know how and very few have a problem.
In which application are you opening the *.csv file? NotePad or some other text editor? What is the cell formatting of your original data in the worksheet? Gord Dibben MS Excel MVP On Wed, 28 Jan 2009 15:40:14 -0800, naomi wrote: Thanks - but it still isn't what i need. It puts 3 or 4 spaces between the contents of each cell. I need a single space. Apparently it can be done, but no-one sems to know how. "David Biddulph" wrote: Other text options are space delimited (.prn) or comma separated (.csv). -- David Biddulph "naomi" wrote in message ... Hi, I need to convert an excel file to a text file which is not tab delimited. Does anyone know how to do this? If I "save as" a text file, whatever option I choose, there are tabs between the cells. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert excel to text file with no tabs
And if a cell contains spaces, should it be surrounded by doublequotes?
You may be able to get more help by describing your requirements. Or maybe you could try building a formula in an unused column: =a1&" "&b1&" "&c1&" "&d1 and drag down as far as you need. Then copy that column and paste into Notepad and save the text file from there. naomi wrote: Thanks - but it still isn't what i need. It puts 3 or 4 spaces between the contents of each cell. I need a single space. Apparently it can be done, but no-one sems to know how. "David Biddulph" wrote: Other text options are space delimited (.prn) or comma separated (.csv). -- David Biddulph "naomi" wrote in message ... Hi, I need to convert an excel file to a text file which is not tab delimited. Does anyone know how to do this? If I "save as" a text file, whatever option I choose, there are tabs between the cells. -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert excel to text file with no tabs
Unfortunately I am one of the few who have a problem.
The csv file is close to what I need, but I need a space instead of a comma. I am opening it with NotePad. I am trying to generate a file to upload to a website for processing and they have very strict requirements for the layout of the file. I cannot enter it straight into NotePad as it is 500 records. The cell layout is as text (even though the data is mostly numbers, but Excel does funny things with the dates if I do it any other way - I need 04/10 etc). There are no spaces within the cells. "Gord Dibben" wrote: It can be done.........many know how and very few have a problem. In which application are you opening the *.csv file? NotePad or some other text editor? What is the cell formatting of your original data in the worksheet? Gord Dibben MS Excel MVP On Wed, 28 Jan 2009 15:40:14 -0800, naomi wrote: Thanks - but it still isn't what i need. It puts 3 or 4 spaces between the contents of each cell. I need a single space. Apparently it can be done, but no-one sems to know how. "David Biddulph" wrote: Other text options are space delimited (.prn) or comma separated (.csv). -- David Biddulph "naomi" wrote in message ... Hi, I need to convert an excel file to a text file which is not tab delimited. Does anyone know how to do this? If I "save as" a text file, whatever option I choose, there are tabs between the cells. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert excel to text file with no tabs
You could try this:
Change your windows regional settings (just temporarily). In windows XP, open control panel Regional and language options|Regional Options tab click the customize button On the Numbers tab, change the list separator to a space character. Then save the file as a .csv file. (And then change the regional settings back to what you used before (comma or semicolon???). ========= Or you could use a formula that does all the formatting and concatenation: =a1&" "&b1&" "&c1&" "&text(d1,"mm/dd")&" "&text(e1,"$0,000.00") naomi wrote: Unfortunately I am one of the few who have a problem. The csv file is close to what I need, but I need a space instead of a comma. I am opening it with NotePad. I am trying to generate a file to upload to a website for processing and they have very strict requirements for the layout of the file. I cannot enter it straight into NotePad as it is 500 records. The cell layout is as text (even though the data is mostly numbers, but Excel does funny things with the dates if I do it any other way - I need 04/10 etc). There are no spaces within the cells. "Gord Dibben" wrote: It can be done.........many know how and very few have a problem. In which application are you opening the *.csv file? NotePad or some other text editor? What is the cell formatting of your original data in the worksheet? Gord Dibben MS Excel MVP On Wed, 28 Jan 2009 15:40:14 -0800, naomi wrote: Thanks - but it still isn't what i need. It puts 3 or 4 spaces between the contents of each cell. I need a single space. Apparently it can be done, but no-one sems to know how. "David Biddulph" wrote: Other text options are space delimited (.prn) or comma separated (.csv). -- David Biddulph "naomi" wrote in message ... Hi, I need to convert an excel file to a text file which is not tab delimited. Does anyone know how to do this? If I "save as" a text file, whatever option I choose, there are tabs between the cells. -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert excel to text file with no tabs
Thank you. The regional settings thing worked
"Dave Peterson" wrote: You could try this: Change your windows regional settings (just temporarily). In windows XP, open control panel Regional and language options|Regional Options tab click the customize button On the Numbers tab, change the list separator to a space character. Then save the file as a .csv file. (And then change the regional settings back to what you used before (comma or semicolon???). ========= Or you could use a formula that does all the formatting and concatenation: =a1&" "&b1&" "&c1&" "&text(d1,"mm/dd")&" "&text(e1,"$0,000.00") naomi wrote: Unfortunately I am one of the few who have a problem. The csv file is close to what I need, but I need a space instead of a comma. I am opening it with NotePad. I am trying to generate a file to upload to a website for processing and they have very strict requirements for the layout of the file. I cannot enter it straight into NotePad as it is 500 records. The cell layout is as text (even though the data is mostly numbers, but Excel does funny things with the dates if I do it any other way - I need 04/10 etc). There are no spaces within the cells. "Gord Dibben" wrote: It can be done.........many know how and very few have a problem. In which application are you opening the *.csv file? NotePad or some other text editor? What is the cell formatting of your original data in the worksheet? Gord Dibben MS Excel MVP On Wed, 28 Jan 2009 15:40:14 -0800, naomi wrote: Thanks - but it still isn't what i need. It puts 3 or 4 spaces between the contents of each cell. I need a single space. Apparently it can be done, but no-one sems to know how. "David Biddulph" wrote: Other text options are space delimited (.prn) or comma separated (.csv). -- David Biddulph "naomi" wrote in message ... Hi, I need to convert an excel file to a text file which is not tab delimited. Does anyone know how to do this? If I "save as" a text file, whatever option I choose, there are tabs between the cells. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i convert text file to excel file ? | New Users to Excel | |||
| How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
| how do I convert an excel file to a flat text file | Excel Discussion (Misc queries) | |||
| Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
| Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
Linear Mode
