how to output Excel file with field separators?

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have an Excel spreadsheet, where some field columns may have 1 word
in it, some fields may have 2, 3 words in each field column, and so
forth. I would like to output this Excel spreadsheet to a text
document.

Is it possible to output an Excel spreadsheet to have a certain
character, let's say | as a field separator?

so if I were to view the text file after the Excel output, it would
look something like this:


John | Doe | 123 Main Street | Bank of
America
Jane | Doe A. | 456 First Ave. West | Wamu
Tom | Smith | 50 South First St. | Citibank
 
I have an Excel spreadsheet, where some field columns may have 1 word
in it, some fields may have 2, 3 words in each field column, and so
forth. I would like to output this Excel spreadsheet to a text
document.

Is it possible to output an Excel spreadsheet to have a certain
character, let's say | as a field separator?

so if I were to view the text file after the Excel output, it would
look something like this:


John | Doe | 123 Main Street | Bank of
America
Jane | Doe A. | 456 First Ave. West | Wamu
Tom | Smith | 50 South First St. | Citibank
Click to expand...


Not exactly. You could use a CSV or TSV file then a text editor to change the
tab or comma to a different character. Neither would insert the spaces though.
 
Your description is a little confusing to me. You ask if a "certain
character" can be specified as a "field separator" (which I would call a
delimiter), but then you show a pipe symbol (|) with several spaces on each
side of it. Further confusing to me is your sample output which seems to be
using the spaces around the pipe symbol coupled with the text being centered
within fields having a width of (nearly) the same number of characters. Can
you clarify exactly what your output should look like?
 
Back
Top