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")
.
|