Problem with incrementing Numbers

[Marcin298]

#hello

Hi, i’m new here and just curious if it’s possible to solve my problem… so…

In column A i got 25 cells with same value:

myphotos_paris_142500.jpg

How to simply rename all that cells in columns with incrementing number 500? Cell A 1 should be:

myphotos_paris_142500.jpg

And next should be:

myphotos_paris_142501.jpg
myphotos_paris_142502.jpg

And max 142999.jpg.

Is it possible by search&swap tool or in cell A 2 and higher i should add a formula? Please help me ?

 

[MARK858]

Afraid I know of no version that LEFT, MID and RIGHT aren't supported since at least Excel 2000

are you saying that the formula below also doesn't work for you in that version

=LEFT(A1;15)&MID(A1;16;6)+1&RIGHT(A1;4)

 

[Marcin298]

Afraid I know of no version that LEFT, MID and RIGHT aren't supported since at least Excel 2000

are you saying that the formula below also doesn't work for you in that version

=LEFT(A1;15)&MID(A1;16;6)+1&RIGHT(A1;4)

Yes; when i put that it gaves me formula error :/ rly weird.

 

[MARK858]

Then I have no idea, post a sample of your worksheet using the boards XL2BB addin (click the XL2BB icon in the reply window for a link to instructions on how to install XL2BB)

 

[Marcin298]

Then I have no idea, post a sample of your worksheet using the boards XL2BB addin (click the XL2BB icon in the reply window for a link to instructions on how to install XL2BB)

Ok will do it after work.

 

[jtakw]

Ok. And how to do it with more harder names?

Start cell is F14 with cell value:

1111111111^^^^OTHERS^^_ENT_GDN_GTW_CO_20160401_142500.pdf

Next should be as previous 142501; 142502 and so on…

I really don’t get it that formula and want it to use for various cell values.

And it does not work on excel 2k16 :/

All the formulas Work on Excel 2016, you just need to translate the Functions according to your Region
like you did in Post #10 picture.

If your various text strings Always end with 6 numbers followed by .???
Use this formula in A2 copied down, formula is already translated to Polish region, use as is:

=LEWY(A1;DŁ(A1)-10)&LEWY(PRAWY(A1;10);6)+1&PRAWY(A1;4)

Ignore the formulas in the following XL2BB table, I'm only showing for illustration purposes

Book3.xlsx
	A
1	myphotos_paris_142500.jpg
2	myphotos_paris_142501.jpg
3	myphotos_paris_142502.jpg
4	1111111111^^^^OTHERS^^_ENT_GDN_GTW_CO_20160401_142500.pdf
5	1111111111^^^^OTHERS^^_ENT_GDN_GTW_CO_20160401_142501.pdf
6	1111111111^^^^OTHERS^^_ENT_GDN_GTW_CO_20160401_142502.pdf
7	abc_def_ghi_123500.mpg
8	abc_def_ghi_123501.mpg
9	abc_def_ghi_123502.mpg
Sheet977

Cell Formulas
Range	Formula
A8:A9,A5:A6,A2:A3	A2	=LEFT(A1,LEN(A1)-10)&LEFT(RIGHT(A1,10),6)+1&RIGHT(A1,4)

 

[MARK858]

If @jtakw is right that you are using a Polish version then the earlier formulas are

=LEWY(A1;15)&FRAGMENT.TEKSTU(A1;16;6)+1&PRAWY(A1;4)

and

=LEWY(A1;47)&FRAGMENT.TEKSTU(A1;48;6)+1&PRAWY(A1;4)

Just in case your data isn't consistent with what you posted