Wonderful...learned something new today.

Have a wonderful weekend.

"RagDyer" wrote:

Just enter the string in A1.
Hover the cursor over the lower right-hand corner of the cell until it
changes from a fat white cross to a skinny black cross.

Then, just click and drag down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jmcclain" wrote in message
...
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