What characters are considered invalid for EDM?
EDM will incorporate any characters into the cell data that it encounters with the exception of characters that it considers to be column separators. The separators are:
Note you can see additional options for changing how punctuation affects detection in the Online Help under the section, 'Multi-token with punctuation (EDM)' by changing the setting: IncludePunctuationInWords