I am new to the forum so please bear with me if I indirectly break any rules......

I am trying to concatenate 3 (or more) cells which contain text in Excel 2010. I use the formula =CONCATENATE(A2," ", B2," ",C2," ",D2) or =A6&" "&B6&" "&C6&" "&D6. My issue is that I don't always have data in all the fields and I have an extra space in the concatenated name when C3 (the middle field) is blank. Is there a way to have a variable command to insert a space when there is text but to not insert the extra space when there is nothing in the referenced cell or remove the extra spaces in my named range/cell? I need 1 space in between each word but if there is no word in the middle field(s) then there is an extra space.

Any help would be appreciated.

For example

Excel Concatenation Question.xlsx