adding a .jpg extension to multiple cells

[robtowler]

Hi, please can anyone tell me how to add .jpg to multiple entries in a column? I have tried this formula
=CONCATENATE(A1,".jpg")
but only works in a seperate column (i cant add anymore columns to my spreadsheet for technical reasons).
Is there another way of doing it ? thanks Rob.

 

[VoG]

Try running this macro

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

 

[Richard Schollar]

Hi Rob

If you want to permanently chnge the values in this column, then you could use your formula, copy down as far as required and then Copy>PasteSpecial>Values over your originals (and then delete the formula column)?

 

[robtowler]

Fantastic, many thanks for your help, this works a treat !!!