Hi!

Try this:

=A2&B2=C2&D2

Biff

"John" wrote in message
...
If I wanted to check that the Surname AND the Firstnames were the same
in each of four columns,
what changes would I make? Ideally I would wwish that the output was as
below:-

Column A Column B Column C Column D
Surname Forename Common entry Surname Common entry Forname

Wilson Bob Wilson
Bob



Jonah