View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default How to autofill strings

Can't do it with autofill, but you could use a formula, the general form
of which would be:

=LEFT(A1,6)&CHAR(MOD(CODE(RIGHT(A1,1))-64,26)+65)



In article ,
"Allewyn" wrote:

Ok, autofill is used to sequence numbers in a row or column. How do I
autofill a column with a string sequence starting with 3 cells such as:
AL0176A
AL0176B
AL0176C
Ideally would want the result of values
AL0176D
AL0176E
AL0176F, etc.
I hope my meaning is clear! :)