Hi,

Just type in AZ6-24-00001 and then drag down with the fill handle.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jOY" wrote in message
...
I AM WORKING HARD TO FIND A WAY TO MAKE THE FOLLOWING POSSIBLE,

COLUMN A

AZ6-24-00001
AZ6-24-00002
AZ6-24-00003..........

I NEED THIS COLUMN TO BE ABLE TO GO ON FOREVER WITH THE CORRECT FORMULA, I
LOOKED AT OHER POSTS AND AM GETTING CLOSE WITH THE POST OF
="AZ6-24-000"&A49
BUT IT DOESN'T QUITE WORK LIKE I NEED, SOME ONE PLEASE HELP!!