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!!