Excel Formula for auto numbers

I am in need of some help.  I have a string of text that I have put together and need a final unique number at the end.  So for example ABL267 is strung together and will be used again I need a nonre...