Soldato
I have a Excel table that has 4 columns headings
And then sample data will be things like ...
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
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