Pipe Character - Any problems using in excel or uses in excel?

[Guest]

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!

 

[Charles Williams]

The pipe character is used in DD remote reference formulae, like this
=STOCK|NYSE!WHITCO

don't know if this will cause you any problems, but AFAIK thats the only
place its used.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

 

[Wondering]

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.