Sunday, 29 January 2017

How to tidy up names in your excel spreadsheet before importing

More Excel Tips and Tricks

We've posted 2 new videos to our SMS Express Help Centre, that shows you two handy little tricks with Excel spreadsheets to tidy up your data.

1) Tidying up the "case" of names in your data.

Does your data have a column of names that looks like this:
JOHN
chris
TErRi


We'll show you how to change it to:
John
Chris

Terri 

Visit the Help Centre

2) Split off Firstname Lastname in excel spreadsheet into separate columns.


You want to send a personalised SMS to your customers, but your list has firstname and lastname in the same cell in Excel?

For example:

How to separate firstname & lastname in Excel












..but you want this so you only personalise with their firstname:

How to separate firstname lastname in Excel
 










Visit the Help Centre and see how