Formula
 

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.

Formula
 

C4 is entered with the number 1200. I want C5 to have "product/1200.jpg"

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

Formula
 

"Maverick" wrote:
C4 is entered with the number 1200. I want C5
to have "product/1200.jpg"[.] Is this even possible?

="product/" & C4 & ".jpg"


----- original message -----

"Maverick" wrote in message
...
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.

Formula
 

Thank you so much! I have been beating my head against the wall for about 3
hrs. I almost had it right, I kept trying to make the C4 C$4$.

Thanks again. :)

"zvkmpw" wrote:

C4 is entered with the number 1200. I want C5 to have "product/1200.jpg"

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

.