Combining text in a cell with a named cell value

U

un1xman

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.
 
U

un1xman

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a macro to alert me when the value of a formula in another sheet changes 1
Excel Typed text appears in wrong cell 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Named Range maker code 9
Selecting a named range, the name of the named range is in a cell 6
Make a maro run upon leaving a cell 0
Add to Dynamic Named Range 4
Get column of named cell 4

Top