how to input consecutive alphabet data? for example a, b, c etc, k_a, k_b, k_c, etc.
N news.microsoft.com Apr 17, 2008 #1 how to input consecutive alphabet data? for example a, b, c etc, k_a, k_b, k_c, etc.
E Earl Kiosterud Apr 17, 2008 #2 news, Put 97 in B1, then copy it down with the fill hjndle holding the Ctrl key. That will give you 98, 99, etc. Put this formula in cell A1: ="k_" & CHAR(B1) COpy it down with the fill handle
news, Put 97 in B1, then copy it down with the fill hjndle holding the Ctrl key. That will give you 98, 99, etc. Put this formula in cell A1: ="k_" & CHAR(B1) COpy it down with the fill handle
