1

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?

migrated from superuser.com Jun 9 at 17:05

This question came from our site for computer enthusiasts and power users.

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

    0

Your Answer

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