Function or code to concatenate

[Maverick27]

Does anyone of any 'function' or 'program unit' that will allow me to "CONCATENATE" the text .jpg to entries in COL C of my worksheet,
See imageshack link
http://imageshack.us/photo/my-images/855/excelj.jpg/

Thanks

 

[VoG]

Try running this

Sub jpg()
Dim LR As Long, i As Long
LR = Range("C" & Rows.Count).End(xlUp).Row
For i = 1 To LR
    Range("C" & i).Value = Range("C" & i).Value & ".jpg"
Next i
End Sub

 

[Peter_SSs]

.. or perhaps just a workshet formula like this (copied down)

Excel Workbook
	C	D
1	Image	.jpg
2	a	a.jpg
3	b	b.jpg
4	c	c.jpg
5	d	d.jpg
6	e	e.jpg
7	f	f.jpg
8	g	g.jpg
9	h	h.jpg
10	i	i.jpg
11	j	j.jpg
Concatenate