Can you do this in excel?

[craig_s]

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

 

[Jan Karel Pieterse]

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 formulaassuming filenames without
extension start in cell A2)

=A2& ".jpg"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Max]

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

 

[Bob Phillips]

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)

 

[Paul Sheppard]

Hi

I know pretty much bugger all about excel, but I really need to d
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 th
".jpg" (and the list needs to be 1016 numbers long!!) I can not wor
out how to append the extension. Can anyone help, I need to work thi
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 (quic
way to do this is to move cursor to bottom right corner of B1 it wil
change to a black cross now double click it will copy the formula al
the way down), then copy that column and paste special values over th
top, delete the first colum

 

[Max]

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)
re: http://tinyurl.com/a79u9
where I've made some requests* on your Sub BrowseSheets()
*if possible

Thanks

 

[Bob Phillips]

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]

Thanks Bob, will do so ..

 

[craig_s]

Thanks everyone, that did it (saved me a few hours of typing
J-P-G, .J-P-G....

Crai

 

[Max]

Thanks everyone, that did it
(saved me a few hours of typing J-P-G, .J-P-G ....

Glad it helped, Craig !