Just add spaces in between 3 words

[hsandeep]

How to concatenate FIRST SECOND & THIRD name in a single cell separated by a blank.
A1: Mark
B1: Hu.
C1=England

Answer:
D1: Mark Hu. England

 

[VoG]

Try

=A1&" "&B1&" "&C1

 

[hsandeep]

Actually, I am trying to make Mark H. England for 3 words i.e. FIRST + Second word's 1st Alphabet + "." + THIRD.
But there are few names with only 2 words.
These names are in 1 cell.
Also, i had splitted the names in 3 cells FIRST SECOND THIRD
Ex:
Input:
A1: Mark
B1: Human
C1: England
D1: Mark Human England
Output required:
E1: Mark H. England
Input#2:
A1: Mark
B1: Human
C1:
D1: Mark Human
Output required:
E1: Mark Human (since 2 words not 3)

 

[gsrikanth]

=a1&" "&left(b1,1)&(if(c1="","",".")&" "&c1)

 

[Matty]

For the examples posted, the following will work:

=IF(COUNTA(A1:C1)=3,A1&" "&LEFT(B1,1)&". "&C1,A1&" "&B1)

Matty

 

[hsandeep]

=a1&" "&left(b1,1)&(if(c1="","",".")&" "&c1)

For 2 words
A1: Mark
B1: Human

It gave me Mark H whereas the correct answer required is Mark Human (Since 2 words only instead of 3)

 

[hsandeep]

For the examples posted, the following will work:

=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)

 

[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)

It works OK for me.

Is there anything in cell C1?

Matty

 

[hsandeep]

It works OK for me.

Is there anything in cell C1?

Matty

C1: "" (BLANK) thr' formula

 

[Matty]

C1: "" (BLANK) thr' formula

In that case, try:

=IF(COUNTIF(A1:C1,"?*")=3,A1&" "&LEFT(B1,1)&". "&C1,A1&" "&B1)

Matty