Rows of Data in Excel to Text File
 

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

Rows of Data in Excel to Text File
 

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.

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Russell" wrote:

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

Rows of Data in Excel to Text File
 

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

"Pranav Vaidya" wrote:

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.

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Russell" wrote:

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