| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| Can you enter a new line in an individual cell within Excel | Excel Discussion (Misc queries) | |||
| how do i create a new line of text within a cell on excel? | Excel Discussion (Misc queries) | |||
| Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
