Excel Formula ...

Soldato
Joined
4 Nov 2006
Posts
2,752
Location
Yorkshire
I have a Excel table that has 4 columns headings

Code:
FULLNAME   /   FORENAME   /   SURNAME   /  KNOWN AS

And then sample data will be things like ...

Code:
JOSEPH BLOGGS   /    JOSEPH    /   BLOGGS   /   JOE

FULLNAME is a concatenation of FORNAMESURNAME however, i'd like to change this to be KNOWNASSURNAME but not everyone in the list will have a "known" as name, only those that are called things like Timothy but like to be called Tim

So what I need is a formula that basically says, if there is a a value in KNOWNAS, then use that, but if not, then egnore it and leave it as FORENAME

Any ideas?

Thanks
 
Back
Top Bottom