Tag Archives: split forename and surname

Split list of names and add title

A recent project brief managed by datanology related to the agreed marketing data of a companies client list. In order to create a more formal yet personal approach, the list of 30,000 names needed to have the title (Mr / Ms) prefixed and to assist in the recording of the emails sent out, the first […]

Get forename and surname from delimited full names

One way of identifying the first and last names in a cell is to use text to columns function and delimit the cells in the column where the name is, by space. This is great in circumstances where only the first name and surname are in the cell to begin with. Once we start having […]

Split Persons First name and Surname

Occasions when a persons first name and surname appear in the same cell in Excel may call for a need to ‘split’ the data apart in order to store in a more structured way, in 2 separate columns. Excel can accomplish this quite easily with the Split function in VBA, but you must also be […]

Splitting and Moving data with VBA

Splitting data can be a cumbersome and highly manual task, and could result in inaccurate data. Splitting data, moving it about and intelligently preparing large amounts of extracted data can be accomplished in seconds using a datanology VBA Solution. In the short example below (data sanitised under DPA) the extracted data which was originally 12,000 […]

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group