For 2 wordsFor the examples posted, the following will work:
Code:=IF(COUNTA(A1:C1)=3,A1&" "&LEFT(B1,1)&". "&C1,A1&" "&B1)
Matty
For 2 words
A1: Messy
B1: Gems
It gave me Messy G. whereas the correct answer required is Messy Gems (Since 2 words only instead of 3)
C1: "" (BLANK) thr' formula
=IF(COUNTIF(A1:C1,"?*")=3,A1&" "&LEFT(B1,1)&". "&C1,A1&" "&B1)