Hi Bob,

Try:

= Trim(CONCATENATE(BC2," ",BN2," ",BB2,","," ",BO2,""))

---
Regards,
Norman



"Bob Reynolds" wrote in message
.. .
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