Formula to increase number

[steveclug]

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

[shg]

Just select the first two cells in that sequence and drag down.

[steveclug]

Thanks but unfortunately I don't know what that means.

I highlighted the first two cells, martin1 and martin 2
I copied and pasted below but not sure if it needs to be paste special or what.

Thanks,

[shg]

Select those two cells.

At the bottom right of the selection marquee is a small square called the fill handle. When you hover the mouse over the fill handle, the cursor changes to a cross. When that happens, left click the mouse and drag down.

[steveclug]

Thanks so much for your help. Got it!

[NBVC]

Here is how to properly mark thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save