Let's say we earmark:

B1: AMD (for input of letters)
B2: 5 (for input of first number)

Put in B3: =$B$1&TEXT($B$2+ROWS($A$1:A1)-1,"000")
Copy B3 down by as many rows as desired, say to B100

B3:B100 will then return the sequential alphanumerics:
AMD005, ... AMD102
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"gizmo" wrote in message
...
Thanks guys for your input!
However, maybe I was not explicit enough...

The goal would be to let one cell unprotected (f. ex. B2), where somebody
will put the adequate value (one day it can be AMD005, other day it can be
AMD558), and then (in adjacent columns or rows) put in place an automatic
formula that will extend this value once and for all, so nobody will have
to
drag it manually...

With sole numbers, the task would be "kinderleicht" (B2 for input, C2 with
formula =B2+1, then D2 with formula C2+1 etc...). However, once we have a
mix of letters and numbers, the whole exercice becomes more complicated
(at
least for me:-)).

If you could help me on this also...