help with pasting automatic number sequence

[nomadman]

This is my first post here and my 10th time actually working on excel. I hope someone can help?

I'm trying to copy a cell with nomadman(1) and paste it on the next row and it will automatically paste it as nomadman(2), next row nomadman(3), and so on. I have to do all the way to nomadman(100).

Essentially, I want the numbers in the ( ) to change every time I paste on the next row. Is there a way to automate this?

Any help is appreciated

[Haseeb Avarakkan]

Hello Nomadman, welcome to the forum.

Enter nomadman in a cell, e: A1. then in the cell where you want to start the numbers

=A$1&TEXT(ROW(A1),"(0)")

then copy down as needed. If you change the text in A1 with new texts, will update all the formula with new name.

[nomadman]

Hi Haseeb, and thank you for the warm welcome!

That's exactly how I wanted it. Thank you!! I hope I'm not pushing my luck, but is it possible to do the same if the content of the cell had an extension? This will be my last question. I don't want to harass you .

example:

nomadman(1).jpg
nomadman(2).jpg
nomadman(3).jpg
nomadman(4).jpg
...
nomadman(100).jpg

[Haseeb Avarakkan]

I don't want to harass you

I don't think you are
____________________

If extension always be .jpg just add &".jpg" after the formula

=A$1&TEXT(ROW(A1),"(0)")&".jpg"

Or enter the extension in a cell. eg: B1, then

=A$1&TEXT(ROW(A1),"(0)")&B$1

copy down.

[nomadman]

GREAT!! Now where is the "Thanks" button??

Thank you so much Haseeb A!