Rows of Data in Excel to Text File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a number of rows of data which I need to get into a text file.

However, what I need is each cell of informaton within these rows to be on
the text file one under the other under the other etc.

Is this possible?

Thanks in advance.
Russell
 
Hi Russell,

This is possible if you save your Excel file as 'Text File'. However please
remember following points

1. Your workbook should have only 1 worksheet.
2. Excel will not save any formatting such as Bold, font color etc.
3. Your text file will be tab delimited.

When you save your workbook using 'Save As', select *.txt (Tet file) as the
file type.
 
Hi there,

Many thanks for your reply. Saving the sheet as a txt file doen't really do
what I need it to do. I think this may explain a little more to what I'm
after.

The Data is currently in Excel as:

John David Paul Joe

In seperate cells. However, I need the data to show in a text file as:

John
David
Paul
Joe

I dont really need it as text delimited, the only factor is that the data is
shown on the text file as above.

Can this be done?

Thanks
Russell
 
Back
Top