can I creat a series with .jpg suffix?

L

leasaac

Hi,

I like to create a series by dragging the corner of the box with a .jp
suffix. For example:

ASD001.jpg
ASD002.jpg
ASD003.jpg

The file name has to be in full and not formula because it has to b
uploaded to a server and the server file server only recognise ful
complete letter by letter link.

Is it possible when there is a suffix? I am using excel 2000
 
A

AlfD

Hi!

Do it as a formula first and then convert to values.

Put ASD001 in A1 and drag down as far as necessary. Should give th
main bit of the sequence.

Put .jpg in B1 and drag down.

Put =A1&B1 in C1 and drag down.

Copy Col C: paste special - values on top of itself.
Delete cols A & B.

Al
 
G

Gord Dibben

In A1 enter ="ASD00"&ROW()&".jpg"

Drag/copy down as far as you wish.

Copy Column A and Paste Special(in place)>Values

Gord Dibben Excel MVP
 
Top