Hello all,
First post to the forums, hoping its a paltry request.
I need a formula to auto increment a set of letters starting with "AAAAA" and when copied moves to "AAAAB". I tried using the CHAR65 option, but it pulls in ASCII? codes. Looking to drop the formula in cell A1 and drag that to the bottom of Excel in the same column, incrementing as it goes, AAAAA, AAAAB, AAAAC, AAAAD, AAAAE, etc.
Thank you in advance!
Jason
You could use something like:
=TEXTJOIN("",FALSE,CHAR(65+MOD(INT((ROWS($A$1:$A1)-1)/(26^{4,3,2,1,0})),26)))
Everyone who confuses correlation and causation ends up dead.
Thank you so much rorya, worked like a charm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks