Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you do this in excel?
Hi I know pretty much bugger all about excel, but I really need to do this: create alpha-numerical list in the following format pin0001.jpg pin0002.jpg pin0003.jpg Etc. I can make the "pin0001" part but other than manually typing in the ".jpg" (and the list needs to be 1016 numbers long!!) I can not work out how to append the extension. Can anyone help, I need to work this out quickly! Thanks in advance Craig -- craig_s ------------------------------------------------------------------------ craig_s's Profile: http://www.excelforum.com/member.php...o&userid=28357 View this thread: http://www.excelforum.com/showthread...hreadid=479368 |
#2
|
|||
|
|||
Can you do this in excel?
Hi Craig_s,
I can make the "pin0001" part but other than manually typing in the ".jpg" (and the list needs to be 1016 numbers long!!) I can not work out how to append the extension. Use an extra column and this formula:(assuming filenames without extension start in cell A2) =A2& ".jpg" Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
#3
|
|||
|
|||
Can you do this in excel?
Put in any starting cell, copy down as required (by 1016 rows ?):
="pin"&TEXT(ROW(A1),"0000")&".jpg" Freeze the results with an "in-place" copy paste special values OK -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "craig_s" wrote in message ... Hi I know pretty much bugger all about excel, but I really need to do this: create alpha-numerical list in the following format pin0001.jpg pin0002.jpg pin0003.jpg Etc. I can make the "pin0001" part but other than manually typing in the ".jpg" (and the list needs to be 1016 numbers long!!) I can not work out how to append the extension. Can anyone help, I need to work this out quickly! Thanks in advance Craig -- craig_s ------------------------------------------------------------------------ craig_s's Profile: http://www.excelforum.com/member.php...o&userid=28357 View this thread: http://www.excelforum.com/showthread...hreadid=479368 |
#4
|
|||
|
|||
Can you do this in excel?
If you put pin0001 in A1 and just drag and copy down (it will increment each
row) Put .jpg in B1 and drag and copy down In C1, enter =A1&B1, then drag and copy that down. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "craig_s" wrote in message ... Hi I know pretty much bugger all about excel, but I really need to do this: create alpha-numerical list in the following format pin0001.jpg pin0002.jpg pin0003.jpg Etc. I can make the "pin0001" part but other than manually typing in the ".jpg" (and the list needs to be 1016 numbers long!!) I can not work out how to append the extension. Can anyone help, I need to work this out quickly! Thanks in advance Craig -- craig_s ------------------------------------------------------------------------ craig_s's Profile: http://www.excelforum.com/member.php...o&userid=28357 View this thread: http://www.excelforum.com/showthread...hreadid=479368 |
#5
|
|||
|
|||
Can you do this in excel?
craig_s Wrote: Hi I know pretty much bugger all about excel, but I really need to do this: create alpha-numerical list in the following format pin0001.jpg pin0002.jpg pin0003.jpg Etc. I can make the "pin0001" part but other than manually typing in the ".jpg" (and the list needs to be 1016 numbers long!!) I can not work out how to append the extension. Can anyone help, I need to work this out quickly! Thanks in advance Craig Hi Craig Do the Pin0001 - Pin 1016, then in the next column use this formula =CONCATENATE(A1,".jpg"), copy down to the bottom of the column (quick way to do this is to move cursor to bottom right corner of B1 it will change to a black cross now double click it will copy the formula all the way down), then copy that column and paste special values over the top, delete the first column -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=479368 |
#6
|
|||
|
|||
Can you do this in excel?
Hi Bob,
Sorry to interject here to catch your radar. If you've got some time later, could you spare a look at this thread in .programming (Subject: Look up worksheet) http://tinyurl.com/a79u9 where I've made some requests* on your Sub BrowseSheets() *if possible Thanks -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#7
|
|||
|
|||
Can you do this in excel?
Hi Max,
I have responded, in the thread for continuity. I need a bit more info please, so take a look at the thread. Regards Bob "Max" wrote in message ... Hi Bob, Sorry to interject here to catch your radar. If you've got some time later, could you spare a look at this thread in .programming (Subject: Look up worksheet) http://tinyurl.com/a79u9 where I've made some requests* on your Sub BrowseSheets() *if possible Thanks -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#8
|
|||
|
|||
Can you do this in excel?
Thanks Bob, will do so ..
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#9
|
|||
|
|||
Can you do this in excel?
:) Thanks everyone, that did it (saved me a few hours of typing . J-P-G, .J-P-G.... Craig -- craig_s ------------------------------------------------------------------------ craig_s's Profile: http://www.excelforum.com/member.php...o&userid=28357 View this thread: http://www.excelforum.com/showthread...hreadid=479368 |
#10
|
|||
|
|||
Can you do this in excel?
"craig_s" wrote:
Thanks everyone, that did it (saved me a few hours of typing J-P-G, .J-P-G .... Glad it helped, Craig ! -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |