Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding ".jpg" to an entire column
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 |
#2
|
|||
|
|||
Please help... I need this done tonight... I swear ive tried it all -- GaryK ------------------------------------------------------------------------ GaryK's Profile: http://www.excelforum.com/member.php...o&userid=25891 View this thread: http://www.excelforum.com/showthread...hreadid=392761 |
#3
|
|||
|
|||
Ill paypal $5 to the person that tells me -- GaryK ------------------------------------------------------------------------ GaryK's Profile: http://www.excelforum.com/member.php...o&userid=25891 View this thread: http://www.excelforum.com/showthread...hreadid=392761 |
#4
|
|||
|
|||
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" wrote in message ... 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 |
#5
|
|||
|
|||
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? Dave GaryK Wrote: 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! -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=392761 |
#6
|
|||
|
|||
Two good ways thanks, Email me both of your adress's and ill paypal it. -- GaryK ------------------------------------------------------------------------ GaryK's Profile: http://www.excelforum.com/member.php...o&userid=25891 View this thread: http://www.excelforum.com/showthread...hreadid=392761 |
#7
|
|||
|
|||
GaryK, Freebee :) buy yourself something. :) Glad it helped. Dave GaryK Wrote: Two good ways thanks, Email me both of your adress's and ill paypal it. -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=392761 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
Adding percentages in a column and automatic formating of contents | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel |