Hi all,
I have a list of clients who are extracted from access but I need to change the saluation from the clients initials to Sir/Madam.
For Example
Surname Firstname Salutation
-------------------------------------------
Smith G Sir/Madam
Andrews A B Sir/Madam
Green R C L Sir/Madam
Jones Mary Mary
Initially, I was just going to highlight any entries in the firstname column that contained a space give the a value of true which would change the saluation to Sir/Madam. However this does not take into account the clients with only on initial.
Any help would be greatly appreciated.
Cheers,
Adam
Bookmarks