Thank everyone for any suggestions

What about 0-9 numbers? there is a limitation to use a number of () within
Excel.
Do you have any suggestions?
Thank everyone very much for any suggestions
Eric

"Dave Peterson" wrote:

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

Will remove the both the $ and the 1.

Eric wrote:

Thank everyone very much for any suggestions
Could you please tell me how to remove numbers and keep characters only?
Thank you very much for any suggestions
Eric

"Satti Charvak" wrote:

take this:

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

put his on cell a1, copy it to anywhere and it will work accordingly.

no fuss no mess
--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Eric" wrote:

Does anyone have any suggestions on how to display the column name?
For example, under column AB, I would like to display "AB" in cell AB1
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

--

Dave Peterson