Help with incrementing number and keeping text the same

[plasma]

Hi there,

I have this string in A1: Player 1

and I'd like to setup excel so no matter what I typed I A1, that all the other predetermined cells auto increment by 1.

For example: If I typed "Player 1" in cell A1, then cells A2 through A40 would change to "Player 2", "Player 3", etc.

Hope that makes sense.

Thank you for any help!!

 

[plasma]

How about in A2 filled down
=LEFT(A1,FIND(" ",A1))&MID(A1,FIND(" ",A1),99)+1

This actually works

Switching to another column is an easy fix in the formula.

Thank you all for the help !!

 

[Fluff]

Glad we could help & thanks for the feedback