saving an excel file as an ASCII text file without delimiters
 

I am new to this group, so have some patience with my stupidity regarding
Excel. I have read much about converting Excel files to other formats, but
can't seem to find the answer I'm looking for. ? - How (or is it possible)
to save an Excel data file as an ASCII text file without any delimiters at
all. I.E. I want my Excel data file to be represented as a pure text file
with rows to be continuous/contiguous data fields and the row ending with a
carriage return/line feed.

Thank you for your time and help,
Scott Sewell
Texas Higher Education Coordinating Board

saving an excel file as an ASCII text file without delimiters
 

Scott:

You can create your own via VBA similar to this:

http://www.dicks-blog.com/archives/2...-your-own-csv/

This shows how to create a CSV, but you can change the code to create
whatever field, delimeters you want.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Sewellst wrote:
I am new to this group, so have some patience with my stupidity
regarding Excel. I have read much about converting Excel files to
other formats, but can't seem to find the answer I'm looking for. ?
- How (or is it possible) to save an Excel data file as an ASCII text
file without any delimiters at all. I.E. I want my Excel data file
to be represented as a pure text file with rows to be
continuous/contiguous data fields and the row ending with a carriage
return/line feed.

Thank you for your time and help,
Scott Sewell
Texas Higher Education Coordinating Board

saving an excel file as an ASCII text file without delimiters
 

Thank you Dick. I'll look into this. I suspected that I would have to do
some creative coding, other than a "point and click" choice within Excel. I
appreciate your time in helping me out. Have a Happy New Year.

Scott

"Dick Kusleika" wrote:

Scott:

You can create your own via VBA similar to this:

http://www.dicks-blog.com/archives/2...-your-own-csv/

This shows how to create a CSV, but you can change the code to create
whatever field, delimeters you want.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Sewellst wrote:
I am new to this group, so have some patience with my stupidity
regarding Excel. I have read much about converting Excel files to
other formats, but can't seem to find the answer I'm looking for. ?
- How (or is it possible) to save an Excel data file as an ASCII text
file without any delimiters at all. I.E. I want my Excel data file
to be represented as a pure text file with rows to be
continuous/contiguous data fields and the row ending with a carriage
return/line feed.

Thank you for your time and help,
Scott Sewell
Texas Higher Education Coordinating Board

saving an excel file as an ASCII text file without delimiters
 

Scott

I assumed you wanted a VBA solution because you posted in .programming.
(You said you were new, I just didn't listen).

But my answers the same because I don't think you can do what you want
through the user interface. Let me know if you have trouble modifying the
code to suit your needs.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Sewellst wrote:
Thank you Dick. I'll look into this. I suspected that I would have
to do some creative coding, other than a "point and click" choice
within Excel. I appreciate your time in helping me out. Have a
Happy New Year.

Scott

"Dick Kusleika" wrote:

Scott:

You can create your own via VBA similar to this:

http://www.dicks-blog.com/archives/2...-your-own-csv/

This shows how to create a CSV, but you can change the code to create
whatever field, delimeters you want.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Sewellst wrote:
I am new to this group, so have some patience with my stupidity
regarding Excel. I have read much about converting Excel files to
other formats, but can't seem to find the answer I'm looking for. ?
- How (or is it possible) to save an Excel data file as an ASCII
text file without any delimiters at all. I.E. I want my Excel data
file to be represented as a pure text file with rows to be
continuous/contiguous data fields and the row ending with a carriage
return/line feed.

Thank you for your time and help,
Scott Sewell
Texas Higher Education Coordinating Board

saving an excel file as an ASCII text file without delimiters
 

Morning Dick,

Sorry I did not get back to you after you responded here. I left the
building!

Anyhow, I will work with your code today and give it a test run. I believe
it will suffice for what I intended. Again, thanks for helping me out. I
was looking for a quick fix, and you gave me just that.

'Preciate the help,
Scott

"Dick Kusleika" wrote:

Scott

I assumed you wanted a VBA solution because you posted in .programming.
(You said you were new, I just didn't listen).

But my answers the same because I don't think you can do what you want
through the user interface. Let me know if you have trouble modifying the
code to suit your needs.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Sewellst wrote:
Thank you Dick. I'll look into this. I suspected that I would have
to do some creative coding, other than a "point and click" choice
within Excel. I appreciate your time in helping me out. Have a
Happy New Year.

Scott

"Dick Kusleika" wrote:

Scott:

You can create your own via VBA similar to this:

http://www.dicks-blog.com/archives/2...-your-own-csv/

This shows how to create a CSV, but you can change the code to create
whatever field, delimeters you want.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Sewellst wrote:
I am new to this group, so have some patience with my stupidity
regarding Excel. I have read much about converting Excel files to
other formats, but can't seem to find the answer I'm looking for. ?
- How (or is it possible) to save an Excel data file as an ASCII
text file without any delimiters at all. I.E. I want my Excel data
file to be represented as a pure text file with rows to be
continuous/contiguous data fields and the row ending with a carriage
return/line feed.

Thank you for your time and help,
Scott Sewell
Texas Higher Education Coordinating Board