Autofill series - 11 character limit?

Hi everyone,

I wonder if someone can help me with an issue I'm having. I'm trying to create an alpha numeric series that will later be pulled from the database to create a barcode. The element is 12 characters Starting @ "C10000000000" and continuing through "C10000011999"
If I delete a character from the element I can type the first few entries into a column and use the handle to generate the series automatically. If I have twelve characters it simply copies the ones I typed in manually over and over. The attached screenshot shows two populated columns the one on the left (A) is the number that DOES NOT work. The one on the right works fine, and as I said if I make the "C" number 11 characters if works perfectly.

Can someone help me with a macro or some other method of creating this series?

Edit: I don't know if it matters but I'm on a Mac.

Originally Posted by sourabhg98

In A2 enter C10000000000

In A3 use this formula-
="C"&SUBSTITUTE(A2,"C","")+1

and copy down

Note- This would work only if "C" is the alphabet in the beginning of code.

Thanks so much sourabhg98! Worked like a charm.

Shareez Saleem, I'm not sure I understand how your method works. I tried it, but didn't get anything. I'm not sure I did it correctly.