May 25, 2013
A customer sent through a spreadsheet with what appeared to be dates displayed in column A in the format YYYY-MM-DD. The spreadsheet was the result of a data export from a bespoke system and the “dates” were actually text entries. The customer wanted the...
Jun 6, 2012
**Download this tutorial (zipped PDF)** A common problem that many people have is where they have a spreadsheet where data in a single column needs to be split into multiple columns. For example a list of employee names where both First Name and Surname are in the...
