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.

Hi,

Do you mean concatenation ...? :

="The test I am looking for is"&VS1

HTH
Carim

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 <carim...@yahoo.com> wrote:
> Hi,
>
> Do you mean concatenation ...? :
>
> ="The test I am looking for is"&VS1
>
> HTH
> Carim