Re: $$Excel-Macros$$ Open pipe delimited file

Hi Aindril Much appreciated for that. I as just wondering if there was a way to tell Excel to open the file this way without having to do that. Like it does for csv files. Mat -- -- Some important links for excel

$$Excel-Macros$$ Open pipe delimited file

Hi all, When I open a pipe delimited file in excel it opens the file but does not put the data per cell as expected. Is there an option to have excel open a pipe delimited file appropriately as it does for comma delimited files? Thanks, Mat

$$Excel-Macros$$ Inbuilt count is counting an empty cell

crosstab's empty cells have 'something in there'. Thanks, Mat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our