Alphanumeric sequence

**El Zorro** · 04-29-2011, 08:57 PM

How can I continue this sequence? :

\1

Basically, it's:

IGSM514501
IGSM514502
IGSM514503

The IGSM part will never change & I only want to increment by one every single time.

Thanks

**jeffreybrown** · 04-29-2011, 09:00 PM

Hello & Welcome to the Board,

Type IGSM514501 in the first cell and then grab the fill handle and drag down.

**El Zorro** · 04-29-2011, 09:06 PM

Dear Lord - I had to google "fill handle". I don't use Excel often but I'm shocked I missed something so obvious.

Thanks very much

**jeffreybrown** · 04-29-2011, 09:12 PM

You're most welcome

**El Zorro** · 04-29-2011, 09:28 PM

While I'm at it, is there an easy way to check that a column has no repeat values?

Oh - and a way to check that all cells in a certain range have the same number of characters?

**jeffreybrown** · 04-29-2011, 09:39 PM

Highlight the column >> Home tab >> Conditional Formatting >> Highlight Cell Rules >> Duplicate Values

**El Zorro** · 04-29-2011, 09:47 PM

You're a legend, sir

**jeffreybrown** · 04-29-2011, 09:57 PM

Just saw your last question.

I'm no formula wizard, but this is what I would think could work.

=SUMPRODUCT(LEN(A1:A11))/COUNTA(A1:A11)

If one cell is off in length from all the others then you would get a decimal number. If all are the same then a whole number.

May be a flaw in my theory but with a little test seems to work

Maybe it could even be modified to

=IF(MOD(SUMPRODUCT(LEN(A1:A11))/COUNTA(A1:A11),1)>0,"One is off","All the same")

which would give you in a cell good or bad