View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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!