Contatenate with blanks

[xxrichbxx]

Hi MrExcel World,

I am trying to concatenate 2 cells, which is easy enough.

The problem I am having is that one if one of the cells is blank I don't want to return anything. Example below;

Concatenate----------------------First Name----Last Name
John Smith-----------------------John-----------Smith
Joe Bloggs------------------------Joe------------Bloggs
(Return blank)-------------------Boris ----------(blank)

Any help would be appreciated

 

[Finalfight40]

Something like this?

=IF(OR(B1="", C1=""), "", B1 & " " & C1)

 

[xxrichbxx]

Something like this?

=IF(OR(B1="", C1=""), "", B1 & " " & C1)

Perfect, thank you very much.