Separating names into last and first names

I had encountered this problem while carrying out mail merge. Usually names are stored in a single field. In order to carry out mail merge for a letter/mailer, last names needs to be stored in a separate field to faciliate merge as Dear Mr/Ms last_name The original list is stored in column A whereas the [...]

Read Full Post »