copy problem

[mark1]

I've got a code that goes 2440A, 2440B, etc.,. I need to
be able to copy over so that Excel will continue the
pattern. Help is appreciated.

 

[Frank Kabel]

Hi
maybe something like
="2440" & CHAR(ROW(1:1)+64)

 

[Jason Morin]

With 2440A in A1, try:

="2440"&CHAR(CODE(RIGHT(A1))+1)

and copy down. It'll work up to 2440Z.

HTH
Jason
Atlanta, GA

 

[Andy B]

Hi

Try:
="2440"&char(row(65:65))
and fill down.