1

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

=IF(ISBLANK(B4),"",CONCATENATE("https://www.url.com/",B4))

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?

Improve this question
2
  • Welcome. Please do share a sheet so as you can be easier helped.
    – marikamitsos
    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.
    – marikamitsos
    Commented Jan 31, 2020 at 21:15

1 Answer 1

Reset to default
0

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:

ARRAYFORMULA

Improve this answer
1
  • 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.