| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining text in a cell with a named cell value
I want to have a single cell in my MS Excel 2003 spreadsheet that
combines both plain text with the value from a Named cell. It would be something like: The text I am looking for is (=VS1). VS1 would be defined on another tab in my workbook as some value like Merry Christmas. The results in my cell would display: The test I am looking for is Merry Christmas. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combining text in a cell with a named cell value
Hi,
Do you mean concatenation ...? : ="The test I am looking for is"&VS1 HTH Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combining text in a cell with a named cell value
YES!!!!! That did it. Thanks so very much. I don't use this kinda
stuff that often and it just drove me crazy trying to figure it out Friday. Thanks again! On Dec 10, 8:12 am, Carim wrote: Hi, Do you mean concatenation ...? : ="The test I am looking for is"&VS1 HTH Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining dates and text in a cell | Excel Worksheet Functions | |||
| Combining text from several cells into 1 cell | Excel Worksheet Functions | |||
| combining picture & text in a cell | Excel Discussion (Misc queries) | |||
| Combining cell reference with text | Excel Discussion (Misc queries) | |||
| Combining text and cell value to create a sentence | Excel Discussion (Misc queries) | |||
Hybrid Mode
