I have the following formula in every cell in my C column:


If the cell in the B column has content, it takes that content and concatenates it onto the end of a URL. It’s very useful, but the formula does not copy to new rows when new rows are created, requiring me to copy the formula to the new cells manually.

I’ve tried to use ArrayFormula and Indirect Address to automatically apply this formula to every cell in the C column (C3:C) but all I could get it to do was concatenate every cell in the B column onto the end of the URL.

How can I write a formula that automatically applies to every column from C3:C which concatenates the content from only the cell immediately to the left?

  • Welcome. Please do share a sheet so as you can be easier helped. Commented Jan 31, 2020 at 18:20
  • Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Commented Jan 31, 2020 at 21:15

1 Answer 1


You do not actually even need the CONCATENATE function.

The simplest way to do this is to apply in cell C3 the following formula:

=ARRAYFORMULA(IF(B3:B<>"","https://www.url.com/" &B3:B,""))

Functions used:


  • Thank you, that’s perfect.
    – Delgado
    Commented Feb 1, 2020 at 0:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.