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!

date: Wed, 27 Aug 2008 08:46:01 -0700   author:   melbatoast

RE: 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!

date: Wed, 27 Aug 2008 08:56:01 -0700   author:   Gary''s Student

Re: 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 news:C8119B08-7031-4519-9975-09E912AF4380@microsoft.com...
>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!

date: Thu, 28 Aug 2008 01:57:11 +1000   author:   macropod lid

Re: 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!

date: Wed, 27 Aug 2008 09:01:35 -0700 (PDT)   author:   Pete_UK

Re: 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 
news:C8119B08-7031-4519-9975-09E912AF4380@microsoft.com...
>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!

date: Wed, 27 Aug 2008 17:17:16 +0100   author:   David Biddulph groups [at] biddulph.org.uk