Full name

[hsandeep]

Column B & column C contains NAMES. But they can be different in the sense either of the column may contain more no. of words which are only separated by 'a blank'. How to get the larger NAME?
EX:
Column B=PETER SHIRT
Column C=PETER ENGLAND SHIRT
Answer is Column D=PETER ENGLAND SHIRT

 

[Gary's Student]

=if(len(b1)>len(c1),b1,c1)

 

[diddi]

could you not just see which is longer and choose it?
eg

=if(len(B1) > Len (C1),B1,C1)

 

[hsandeep]

This formula works. But sometimes column C=#N/A & column B=value (alphanumerical). Answer should be=column B.
If column B=#N/A & column C=value (alphanumerical). Answer should be=column C.

 

[Peter_SSs]

Try

=IF(ISNA(B2),C2,IF(ISNA(C2),B2,IF(LEN(B2)>LEN(C2),B2,C2)))

 

[hsandeep]

This was exactly what I was looking for. Thanks.