Hi All, I have a large contact list. Last names are in column A, first names in column B, their address in column E. Everything is in capitol letters, I need to change them to proper names (SMITH - Smith). I have to delete the column with the capital letters because we need to print this document & don't want both columns.

Any ideas??