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


| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy