Hi - I have a three column sheet (Forename, Middle Name, Surname) and I'm using a simple concatenate formula to join the three names together with a " " in between each name. That's working fine. But when a person does not have a middle name I'm ending up with two " " (spaces) in between the first & last name...!!! I know this should be simple but how do I avoid having the two spaces between the forename and surname if the person has not middle name?

All help much appreciated.

Monty