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) |