To generate this series:
4NJ8CD001AA
4NJ8CD001AB
4NJ8CD001AC

Put in any starting cell, say in B2:
="4NJ8CD001"&CHAR(INT((ROWS($1:1)-1)/26)+65)&CHAR(MOD(ROWS($1:1)-1,26)+65)
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"midsummer" wrote:
Hi,
I'm working for LCD company.

I'm looking for the easier way to input 'panel ID's.
Here is the example.

4NJ8CD001AA
4NJ8CD001AB
4NJ8CD001AC
....

Even though I thought Auto-filling function should work, Unfortunately, it
didn't seem
to work. Instead, it generate the data like this.

4NJ8CD001BA
4NJ8CD002BA
4NJ8CD003BA
4NJ8CD004BA
4NJ8CD005BA
4NJ8CD006BA
4NJ8CD007BA

Does anyone know how to solve my problem?

Please, help me. It's annoying to input thousands of panel ID one by one.






--
Thanks for your concerns!