Formula issue - wish to exclude 'blank' value from appearing in concatenation

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

You could just insert IF statement to omit middle name if it's length is equal to 0.

Hi Ron - that has worked perfectly! Thank you so much - I've never used that function before so I'll need to do some homework on how that works exactly, but you've just made me happy! Nice one brother.

Hi wator - I have tried figuring that out but couldn't work it out - I'm learning to use Excel so not quite up to speed with IF statements yet. Thanks.