Prev: In Excel how do you rearrange a list of address's in alphaeticalo
Next: custom format changes to special
From: Bob Ryan on 9 May 2010 10:53
Got it, and then realized I can put the text that will never change in
one cell, the sheet name formula in another cell and either use the
concatenate function or "&" to combine the two, which would then feed
the chart title. Thank you.
Bob

On 5/9/2010 9:05 AM, Don Guillett wrote:
> Just amend your cell formula to
> ="Total Income for " &
> MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
>

First  |  Prev  | 
Pages: 1 2
Prev: In Excel how do you rearrange a list of address's in alphaeticalo
Next: custom format changes to special