Hi, thanks... rolling on the floor (not at your darn fingers) because been
trying to figure that out... my darn fingers was the issue: once have
(many) long equations, past 1 line, "IT COVERS" the column letter you are
trying to work in. Suprised that MS can't think that far ahead. Anyways,
you cannot figure out what you were doing a few seconds ago. The problem:
when re-arranging columns, forget to change row of artificial column labels..
will never have to do that again.

Thanks!.. -nastech

"Dave Peterson" wrote:

Darn fingers...

=SUBSTITUTE(SUBSTITUTE(CELL("address",A1),"$",""), "1","")

Will return the column letter for A1.



nastech wrote:

Simply trying to modify equations (in columns) where long equation covers
column letter. Currently using row to designate column by hand, but when
cut-paste columns run into problems, just need to have same column Letter
Position re-displayed. Thanks...... currently have:

=CELL("COL",A67) gets a number, need column letter re-displayed

also: not familiar with arrays or vlookup, if answer & you have subject
info links
Thanks!....
-Nastech

--

Dave Peterson