Blog Archives

What is a .CSV file?

A .CSV file is a comma delimited file. It is a text file containing values separated by commas. If you open a .CSV file with Notepad.exe you will see something like this: FirstName,LastName,Company,City David,Smith,ABC Trading,New York Mike,Saunders,XYZ Industries,London If you

Posted in Spreadsheets

How to split a name using MS Excel 2007

For the purposes of data import / export it is often necessary to split a name into the first name and last name, for example when importing contact data into a CRM system. So how do you split a name

Posted in Spreadsheets