Thread: How to enter an Excel cell reference into a line of text in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default How to enter an Excel cell reference into a line of text in Excel
="Your invoice number is "&A4

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"WUDFAL" wrote in message
...
For instance, if cell A4 has a value of 14, how can I enter text in cell
A5
that says "Your invoice number is", then reference cell A4, such that the
final result in cell A5 is" Your invoice number is 14?

Reply With QuoteReply With Quote