adding ".jpg" to an entire column

G

GaryK

Hello all, I have a simple task that is very time consuming. I have a
column (column B) that has part numbers in it. I also use the part
numbers for the pictures on my website. I need to add a .jpg to every
part number in that column and theres quite a few rows. Any help would
be appreciated!

Thanks!
 
L

Lomax

GaryK

assuming the part numbers start in cell b1;
Place this in c1 and fill down. =b1 & ".jpg"
after you have completed the fill down you can copy and paste special values
to remove the formulas.
Hope this helps
lomax
 
P

Piranha

Gary,
If you want a macro try this, put it in a general module:

Sub InsertStuffAfter()
Dim cell
For Each cell In Selection
cell.Value = cell.Value & ".jpg"
Next cell
End Sub

"Select the cells you want changed" and then run the macro.

This help?
 
Top