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.

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

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