View Single Post
  #1   Report Post  
Mike
 
Posts: n/a
Default Custom list - how to include commas?

In Excel 2002 (or any version), under Tools, Options, Custom Lists, you can
either manually enter list items (separated by a comma or new line) or
import them. If you manually enter them, the entries themselves cannot
include a comma. However, if you *import* the list, the comma is okay.
I've tried delimiting with a single quote, double quotes, and using no
comma, but Excel breaks up the line at the comma. Is there a way, aside
from importing, to have a comma as part of the custom list entry? TIA,

Mike