Hello

I use this formula in many of my spreadsheets for last/first/middle name:


=CHAR(10)&
UPPER(IF(C4="","",C4&", "&C5&IF(C6="",""," "&C6)&REPT(CHAR(10),2))
&IF(D4="","",D4&", "&D5&IF(D6="",""," "&D6)&REPT(CHAR(10),2))
&IF(E4="","",E4&", "&E5&IF(E6="",""," "&E6)&REPT(CHAR(10),2))
&IF(F4="","",F4&", "&F5&IF(F6="",""," "&F6)&REPT(CHAR(10),2))
&IF(G4="","",G4&", "&G5&IF(G6="",""," "&G6)&REPT(CHAR(10),2))
&IF(H4="","",H4&", "&H5&IF(H6="",""," "&H6)&REPT(CHAR(10),2))
&IF(I4="","",I4&", "&I5&IF(I6="",""," "&I6)&REPT(CHAR(10),2))
&IF(J4="","",J4&", "&J5&IF(J6="",""," "&J6)&REPT(CHAR(10),2))
&IF(K4="","",K4&", "&K5&IF(K6="",""," "&K6)&REPT(CHAR(10),2)))


Is there a more concise formula for this since it is so repetitive?

Thanks for any help!

VR/Lost