I have the following formula in a cell in Excel
=CONCATENATE(BC2," ",BN2," ",BB2,","," ",BO2,"")
The result would normally be Bob N. Reynolds
or Bob Reynolds

My question is how do I remove the extra space when there is no middle
initial in cell bb2 so it will read
Bob Reynolds with one space.

Thanks so muych
Bob