Sequential forumula to add a number in the cell below to data

[IGinc]

I need a solution to add a number, the data in the cell is currently in this format MD83ERHU-5.jpg.

My question is how can I get the cells below to be MD83ERHU-6.jpg, MD83ERHU-7.jpg, and so on.

One solution I thought of was cells like such

MD83ERHU
-
5
.jpg
concatenate formula
formula to add + 1 to (5)

I cannot recall the formula, but am quite confident, there is way to create a formula that can make the cell one number higher than the cell above, and fill down.

Your help with my solution is appreciated, or an easier way to change MD83ERHU-5.jpg add + 1 to each cell and just fill down would be even better .

Thanks!

 

[Matty]

Maybe:

=LEFT(A1,LEN(A1)-5)&--MID(A1,LEN(A1)-4,1)+1&".jpg"

In A2 and copied down (assuming MD83ERHU-5.jpg sits in A1).

Matty

 

[HalfAce]

If you were to use a formula like this:

="MD83ERHU-"&ROW()&".jpg"

your entries would end up like this:
MD83ERHU-5.jpg if it's in row 5.
MD83ERHU-8.jpg if it's in row 8, etc.

That sound like it might work?

 

[IGinc]

Matty and HalfAce.

Tried both - both worked, just wanted to thank you both for saving me time!

This board is great!