I have a column that is in the format: AK2018-001
I need a formula that will auto add as the column continues down; for example:
AK2018-101
AK2018-102
AK2018-103
I can't use (=A45+1) because of the "AK2018-" prefix.
I am stuck and I'm hoping there's a simple solution that I've overlooked.
Thanks in advance!
EDIT: My list starts at AK2018-001 in column A3
Bookmarks