adding ".jpg" to an entire column

[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!

[GaryK]

Please help... I need this done tonight... I swear ive tried it all

[GaryK]

Ill paypal $5 to the person that tells me

[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
"GaryK" <[email protected]> wrote in
message news:[email protected]...
>
> 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!
>
>
> --
> GaryK
> ------------------------------------------------------------------------
> GaryK's Profile:
> http://www.excelforum.com/member.php...o&userid=25891
> View this thread: http://www.excelforum.com/showthread...hreadid=392761
>

[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.

I believe Bob Philips gets the credit for this code.

This help?
Dave

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!

[GaryK]

Two good ways thanks,

Email me both of your adress's and ill paypal it.

[Piranha]

GaryK,

Freebee buy yourself something.
Glad it helped.

Dave

Two good ways thanks,

Email me both of your adress's and ill paypal it.

[reynoldsn8]

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
"GaryK" <[email protected]> wrote in
message news:[email protected]...
>
> 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!
>
>
> --
> GaryK
> ------------------------------------------------------------------------
> GaryK's Profile:
> http://www.excelforum.com/member.php...o&userid=25891
> View this thread: http://www.excelforum.com/showthread...hreadid=392761
>

hello!

I needed to do this today. I took a chance and google it -- found this site and bingo, it worked! Very cool.
-Nancy