comma delimited text

K

Karl

What do you do when you want to save a document as a comma delimited text
file, but your document has commas in the data fields (i.e. a company named
Johnson, Smith, and Jones, C.P.A.)? I tryed using comma delimited text for
making various lists, labels, etc and found that it takes the above name and
makes each name and makes it into a seperate entry. Any help appreciated.
 
G

Graham Mayor

Change the field delimiter from a comma to something else not used in the
data - e.g. |

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
K

Karl

Thanks, think that will work!


Graham Mayor said:
Change the field delimiter from a comma to something else not used in the
data - e.g. |

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import a comma delimited file & match records 3
macro to place comma delimited text into a table 8
ASK Field Formatting 1
Excel VBA - Force 4 commas into a text field on userform 7
Need help modifying code 0
What are header record delimiters? 2
looping through comma delimited text 2
looping through comma delimited text 1

Top