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

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

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

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

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

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

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

Can you do this in excel?
 

Thanks Bob, will do so ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

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

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