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

M

melbatoast

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

Pete_UK

Put this in A2:

=A1 & " earnings per share"

and this in A3:

=A1 & " net income"

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Locking a cell reference in a formula 1
Working with Time in formulas/calculations 2
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
Conditionally format a cell using a list of data defined in a rang 2
Use a cell, containing a tabname, in a function 2
Multiplying the contents of two cells a variable number of times 1
Retaining cell reference in destination, when sorting source file 3

Top