Commas within fields in .csv files

		Microsoft Office Forums > Microsoft Excel > Excel
Commas within fields in .csv files

01-29-2015, 09:24 PM

macropod

Windows 7 64bit Commas within fields in .csv files

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,363

Such fields require the use of double-quote pairs to enclose the content. For example:
123,"456,789",0123

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
How to use mid or left functions to seperate city,st,zip with no commas	sinaranje	Excel	4	11-11-2014 10:52 PM
auto populate fields for multiple files w/in folder	jbyrd	Word	0	07-21-2014 07:35 AM
No inverted commas in word 2013.	tonycrossley	Word	3	01-27-2014 04:55 PM
Word 2010 - DOCX File with fields -> PDF with fields	senglory	Word	2	03-27-2012 10:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:41 AM.