Alphanumeric sequence

[El Zorro]

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]

Hello & Welcome to the Board,

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

[El Zorro]

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]

You're most welcome

[El Zorro]

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]

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

[El Zorro]

You're a legend, sir

[jeffreybrown]

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