Formula

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.
 
Z

zvkmpw

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top