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

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

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

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

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

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

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

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

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

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