MS excel comma

August 6, 2009 at 10:23:12
Specs: Windows XP
how do i add a comma to an adress (ie 123 main street, suite 111) in excel without getting the quote marks upon export??????

See More: MS excel comma

Report •


#1
August 7, 2009 at 05:24:52
Without actually verifying...
Try formatting the cell or cells as Text.

Bryan


Report •

#2
August 7, 2009 at 06:42:58
terrence: how do i add a comma to an adress (ie 123 main street, suite 111) in excel without getting the quote marks upon export??????
Export? Do you mean save as one of the clear text formats? You can't. At least not without manually writing the file with VBA.

Report •

#3
August 7, 2009 at 08:26:57
found no way to do it in excel, however was able to export as txt and remove the " " in notepad. thanks T!

Report •

Related Solutions


Ask Question