Alun Rowe

ramblings about cars, tech, web development and more. BOTB Winner in 2010

Category: excel

Adding days to a date in Excel

It’s one of those things I end up googling overtime I need to do it so, in the spirit of this blog, I’m going to write down everything I learn about this topic here so I know where to find it in the future!

Excel/VBA equivalent of the PHP Implode function

On a recent data import between Xero and OnePageCRM I needed to turn multiple column address into an address list into a single line. For this I needed the PHP implode function so I wrote one for Excel

Excel CSV import returns an SYLK file format error

How to fix Excel has detected that ‘balhblah.csv’ is a SYLK file, but cannot load it. Either the file has error or it is not a SYLK file format. Click OK to try to open the file in a different format’ errors

Powered by WordPress & Theme by Anders Norén