I have a spread sheet that holds client property details, some properties are held singly others are held jointly.
I would like to be able to create a new column entitled "ClientSalutation" that will record either "Client1Firstname1" or "Client2Firstname" or "Client1Firstname and Client2Firstname" as the correct way of addressing correspondence to them.
I had looked at using the =a1&" and "&b2 formula in the "ClientSalutation" column but this adds the "and" to a record where the property is held in a single name only .
Is it possible to create formula that will allow Excel to recognise where Client2Firstname is empty and therefore not include "and" in the "ClientSalutation" column thus creating the correct entry in the "ClientSalutation" column.
Cheers
Stuart
Bookmarks