Excel 2007 : Easy one, need help

I need to increase a number, but there is a recurring word in the cell.

Example:

martin1
martin2
martin3
martin4

Formula for increasing the number?

Thanks in advance

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

Please also modify the title on your existing thread in accordance with Forum guidelines... the title should relate to the underlying issue.