Can you do this in excel?

**craig_s** · 10-26-2005, 04:55 AM

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

**Paul Sheppard** · 10-26-2005, 05:21 AM

Originally Posted by 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

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

Jan Karel Pieterse · 10-26-2005, 06:05 AM

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

Max · 10-26-2005, 06:05 AM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Bob Phillips · 10-26-2005, 06:05 AM

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Max · 10-26-2005, 06:05 AM

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Bob Phillips · 10-26-2005, 07:05 AM

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" <[email protected]> wrote in message
news:%[email protected]...
> 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
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
>
>

Max · 10-26-2005, 07:05 AM

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

**craig_s** · 10-26-2005, 08:45 AM

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

Craig

Max · 10-26-2005, 11:05 AM

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