Reference a number from one cell in the text of another cell?
 

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!

Reference a number from one cell in the text of another cell?
 

=A1 & "earnings per share"
=A1 & "net income"

--
Gary''s Student - gsnu200801


"melbatoast" wrote:

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!

Reference a number from one cell in the text of another cell?
 

Hi,

In A2: =A1&" earnings per share"
In A3: =A1&" net income"

--
Cheers
macropod
[MVP - Microsoft Word]


"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!

Reference a number from one cell in the text of another cell?
 

Put this in A2:

=A1 & " earnings per share"

and this in A3:

=A1 & " net income"

Hope this helps.

Pete

On Aug 27, 4:46*pm, melbatoast
wrote:
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!

Reference a number from one cell in the text of another cell?
 

=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!