Fill Series Contains _ & .jpg

[muhammad susanto]

hi all..

how to make fill series number that contains _ & text (.jpg) like this below:

hitung R2 kejari siak by sst.xlsb
	L	M
5	foto_1	foto_2
6	1_1.jpg	1_2.jpg
7	2_1.jpg	2_2.jpg
8	3_1.jpg	3_2.jpg
9	etc..
master

thank in advance..

.sst

 

[Trevor G]

You can use formatting to achieve this: Format Cells >> Custom format #"_1.jpg"

Book2
	A
5	1_1.jpg
6	2_1.jpg
7	3_1.jpg
8	4_1.jpg
9	5_1.jpg
10	6_1.jpg
11	7_1.jpg
Sheet1

Cell Formulas
Range	Formula
A6:A11	A6	=A5+1

 

[muhammad susanto]

hi..thank you,,,sorry, how about for a reason, if don't use Custom Format and not use Vba too.

 

[Trevor G]

Then use a helper column:

Book1
	A	B
6	1	1_1.jpg
7	2	2_1.jpg
8	3	3_1.jpg
9	4	4_1.jpg
10	5	5_1.jpg
11	6	6_1.jpg
12	7	7_1.jpg
13	8	8_1.jpg
14	9	9_1.jpg
15	10	10_1.jpg
16	11	11_1.jpg
Sheet1

Cell Formulas
Range	Formula
B6:B16	B6	=A6&"_1.jpg"
A7:A16	A7	=A6+1