Formula

  • Thread starter Thread starter Maverick
  • Start date Start date
M

Maverick

I'm not sure this can even be done but here goes.
What I need is when a number is entered into a cell, I want another cell to
include that number in it along with text.
Example:
C4 is entered with the number 1200. I want C5 to have "product/1200.jpg"
Is this even possible?
Thanks in advance.
 
C4 is entered with the number 1200. I want C5 to have "product/1200.jpg"

One way:
=CONCATENATE("product/",C4,".jpg")
 
Back
Top