adding ".jpg" to an entire column

**GaryK** · 08-03-2005, 08:49 PM

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** · 08-03-2005, 09:23 PM

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

**GaryK** · 08-03-2005, 09:32 PM

Ill paypal $5 to the person that tells me

Lomax · 08-03-2005, 11:05 PM

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" <GaryK.1t7tea_1123117507.1221@excelforum-nospam.com> wrote in
message news:GaryK.1t7tea_1123117507.1221@excelforum-nospam.com...
>
> 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** · 08-03-2005, 11:55 PM

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

Originally Posted by 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** · 08-04-2005, 02:23 AM

Two good ways thanks,

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

**Piranha** · 08-04-2005, 02:48 AM

GaryK,

Freebee

buy yourself something.

Glad it helped.

Dave

Originally Posted by GaryK

Two good ways thanks,

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

**reynoldsn8** · 04-15-2013, 12:03 PM

Originally Posted by 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" <GaryK.1t7tea_1123117507.1221@excelforum-nospam.com> wrote in
message news:GaryK.1t7tea_1123117507.1221@excelforum-nospam.com...
>
> 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