Thread: Combining text and cell value to create a sentence
View Single Post
  #5   Report Post  
JustinLabenne JustinLabenne is offline
Junior Member
  
Location: Ohio
Posts: 19
Default
Try this one:

="Recoveries " &TEXT(E2,) & " from " &TEXT(B1,) & " to " &TEXT(A1,)
__________________
Justin Labenne
www.jlxl.net
Reply With QuoteReply With Quote