Cell name
 

I'd like to insert the cell name (found in the upper left-hand corner of the
sheet) into each cell automatically. For instance, I have an F row, and I'd
like for each cell to say the column letter + row number. How can I do this?
Thankks

Cell name
 

Use:

=SUBSTITUTE((LEFT(ADDRESS(1,COLUMN()),3)),"$","") & ROW()

--
Gary''s Student - gsnu200766


"excelnewbie" wrote:

I'd like to insert the cell name (found in the upper left-hand corner of the
sheet) into each cell automatically. For instance, I have an F row, and I'd
like for each cell to say the column letter + row number. How can I do this?
Thankks

Cell name
 

Hi,

Put this in F1 and drag down

=ADDRESS(ROW(),6,4)

Mike

"excelnewbie" wrote:

I'd like to insert the cell name (found in the upper left-hand corner of the
sheet) into each cell automatically. For instance, I have an F row, and I'd
like for each cell to say the column letter + row number. How can I do this?
Thankks

Cell name
 

you may want to drag across so change to this

=ADDRESS(ROW(),COLUMN(),4)

Mike

"excelnewbie" wrote:

I'd like to insert the cell name (found in the upper left-hand corner of the
sheet) into each cell automatically. For instance, I have an F row, and I'd
like for each cell to say the column letter + row number. How can I do this?
Thankks