Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zvkmpw zvkmpw is offline
external usenet poster
  
Posts: 153
Default Formula
C4 is entered with the number 1200. I want C5 to have "product/1200.jpg"

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

Reply With QuoteReply With Quote