how to generate a series with a suffix?

L

leasaac

I want to generate a series but I can't get to do it well because ther
is a suffix at the end of the series.

i.e.(what I want)

DSA00001S
DSA00002S
DSA00003S
DSA00004S

When I try to pull and drag the corner of the boxed information, i
comes out with,(Not what i want)

DSA00001S
DSA00002S
DSA00001S
DSA00002S

How to do it
 
A

Andy B

Hi

Try something like:
="DSA"&TEXT(ROW(),"00000")&"S"
and fill down.
Once done, you might want to fix the values with Copy and Paste Special. . .
Values.
 
Top