Cell name

[excelnewbie]

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

 

[Gary''s Student]

Use:

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

 

[Mike H]

Hi,

Put this in F1 and drag down

=ADDRESS(ROW(),6,4)

Mike

 

[Mike H]

you may want to drag across so change to this

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

Mike