Referring to columns in the text of a cell

[Gerry]

I would like to put the following text in a cell: "Refer to data in columnH". However, I know that sometime down the line I will insert other columns into my spreadsheet which means the text reference to column H will be wrong. Can I make the "H" variable within the text string such that it can point to the correct column after my various insertions and removals of other columns has been completed. TIA, Gerry.

 

[isabelle]

hi Gerry,

="Refer to data in column "&SUBSTITUTE(ADDRESS(1,COLUMN(H1),4),"1","")

isabelle

Le 2013-01-31 06:37, Gerry a écrit :

I would like to put the following text in a cell: "Refer to data in column H".

However, I know that sometime down the line I will insert other columns
into

my spreadsheet which means the text reference to column H will be wrong.

Can I make the "H" variable within the text string such that it can
point to the

correct column after my various insertions and removals of other columns
has been completed. TIA, Gerry.

 

[Gerry]

I would like to put the following text in a cell: "Refer to data in column H". However, I know that sometime down the line I will insert other columns into my spreadsheet which means the text reference to column H will bewrong. Can I make the "H" variable within the text string such that it canpoint to the correct column after my various insertions and removals of other columns has been completed. TIA, Gerry.

Thanks Isabelle. That's neat.