Summing Text
enter this formula and fill down as far as you want (not more than 26 rows(!)):
=CHAR(96+ROW(A1))
"scott" wrote:
how does the formula =a1+1 work for letters instead of numbers? I have in c2
the letter "a" and in c3 i want to add b..which is simple by typing "b"...but
if i need 10 or more letters in a2:a25 or a28, how does the formula work?
sorry for the confusion....and thanks for the help
|