=A1&" earnings per share"
=A1&" net income"
--
David Biddulph

"melbatoast" wrote in message
...
I would like to setup the following:

cell A1: 2009E
cell A2: =A1 earnings per share
cell A3: =A1 net income

Such that cells A2 and A3 read: "2009E earnings per share" and "2009E net
income". The purpose would be able have various cells throughout a
template
that cannot be grouped into a table that explicitly states '2009E data'
Thx!