Fill Series Number with Adding Consistent Text/Number

[muhammad susanto]

hi all..

how to make fill series number like this :
without helper column and no macro

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]input/entry
[/TD]
[TD]after formula
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1_1.jpg
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]2_1.jpg
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]3_1.jpg
[/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]100_1.jpg
[/TD]
[/TR]
</tbody>[/TABLE]

any help, much appreciated..

m.susanto

 

[AlanY]

try

=A1&"_1.jpg"

 

[muhammad susanto]

sorry Alan, i have mistake should be like this

Excel 2013 64 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

F​

[/th][th]

G​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

3​

[/td][td]entry[/td][td]after formula[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td]

1​

[/td][td]1_1.jpg[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td]

1​

[/td][td]1_2.jpg[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td]

1​

[/td][td]1_3.jpg[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td]

1​

[/td][td]1_4.jpg[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td]

2​

[/td][td]2_1.jpg[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

9​

[/td][td]

2​

[/td][td]2_2.jpg[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

10​

[/td][td]

2​

[/td][td]2_3.jpg[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

11​

[/td][td]

2​

[/td][td]2_4.jpg[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

12​

[/td][td]

3​

[/td][td]3_1.jpg[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

13​

[/td][td]

3​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

14​

[/td][td]

3​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

15​

[/td][td]

3​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

16​

[/td][td]etc[/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

 

[AlanY]

try

=A1&"_"&COUNTIF(A1:$A$1,A1)&".jpg"

 

[muhammad susanto]

hi alan, worked great!!!
thank u very much...

 

[AlanY]

you're welcome