Hi Mike,

Del has given you the correct solution. I just wanted to clarify:

In a spreadsheet cell enter a formula such as:

="The result is: "&B2&" as of "&TEXT(NOW(),"DDDD - MMM. D, YYYY")

This example shows you how to concatenate text with a cell's contents with a
function's results. Many books state that you can only concatenate text
entries but you can concatenate numbers, dates, text, cell references,
formulas and functions.


--
Cheers,
Shane Devenshire


"Del Cotter" wrote:

On Sat, 12 Jan 2008, in microsoft.public.excel.charting,
Mike Z said:

I am trying to have my chart titles auto populate with both text and a
reference field. I want the title text box to read "Text 'contents of a
referenced cell'". Is this possible? I can have the title text box display
contents of a referenced cell, but cannot add text to the title text box so
that is displays both.

You can't make the title be a formula, but you can make it be "contents
of a referenced cell".

So make it be the contents of a cell which is *itself* a formula. That
referenced cell can be "Text & 'contents of another referenced cell'"
easily.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.