alphanumeric counter

[mr223]

I'm probably making this harder than it needs to be, but here goes. I need to automatically populate a column with an alphanumeric MFR0001 to MFR9999 and am currently using the formula below to add 1 to the start point (A1)...

A1=MFR0001
Formula in A2 =LEFT(C1,3)&(RIGHT(C1,4)+1)

This works perfectly if I start at MFR1000, but breaks and drops the 000 if I use it on the number I need to start with (MFR0001).

Can anyone give a guy a hand on this?

[NBVC]

Try:

=LEFT(C1,3)&TEXT(RIGHT(C1,4)+1,"0000")

[mr223]

THANK YOU!

I thought I tried that already, but missed the simplicity of it (I kept trying to add the TEXT function into the mix with the "0000").

Thanks again.

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save