I would like to make a chart title have a mix of letters and a cell reference
formula similar to what I do in other cells. For example:

="text" & (left(A1,4))

I would hope this is possible but it keeps giving me an error. I have used
just the ="text" & A1 and it works but when I add the formula, it says no.

Any ideas?

Jeff