Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Could someone help me?
I am trying to create a social media keyphrase strategy using keywords. I would like to know if Google Sheets could return a blank cell if one of the cells in the concatenate formula is blank?
this formula concatenates columns A, B and C only if all 3 cells per row are not empty:
=ARRAYFORMULA(IF(LEN(A1:A)*LEN(B1:B)*LEN(C1:C), A1:A&" "&B1:B&" "&C1:C, ))
Required, but never shown