Thread: Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JoeU2004 JoeU2004 is offline
external usenet poster
 
Posts: 16
Default 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.