Enter SPFL001 in A1

Right-click the fill handle and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP

On Fri, 26 Sep 2008 14:34:03 -0700, jmcclain
wrote:

I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value in?

Any help is appreciated.

Jon