How to enter an Excel cell reference into a line of text in Excel
 

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?

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?

How to enter an Excel cell reference into a line of text in Excel
 

Another method...........

Do not use A5 to reference A4, just format A4 to NumberCustom "Your Invoice
Number is " ###


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 12:11:01 -0800, WUDFAL
wrote:

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?