Don't try to use the pipe character in a name such as a file name. It's
illegal (as are \, ?, :, *, ", <. - just like DOS). As data, the pipe
character is fine.

"BenS" wrote in message
...
I am going to be receiving csv files that contain the "pipe" characters ||
but are not to be used as delimiting characters.

I am not aware of any use of | in Excel and have tried to see if I can
create any problems or unexpected results by using it, and so far I have
not.

Does anyone know if this could create problems? My eventual plan is to
manipulate this file via macro or VB and then send parts of it out via
email
automatically.

Thanks!