how to output Excel file with field separators?

[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

 

[Dave Mills]

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

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.

 

[Rick Rothstein]

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?

 

[Justin Case]

Hi,

Chip Pearson has written a user defined function called "StringConcat"
that you can find here:

http://www.cpearson.com/excel/stringconcatenation.aspx

It takes a range of cells and concatenates them with any delimiter you
like, ignoring empty cells if necessary.

Regards,
Justin