I have a project plan that I'm storing in Excel. There are IDs assigned to
tasks that are alphabetical and numerical. For example:

A-1, A-2, A-3...

When a new row is insterted, is there a way to automatically generate the
next ID for the new task?

Thanks for any help that can be provided!