Fill Series help?

Q

Q3Rosco

Hi

if i have somthing like "ftp://anything/1.zip" in A1 an
"ftp://anything/2.zip" in A2, how can i just drag this down ONL
changing the NUMBER so it will be 3.zip, 4.zip, 5.zip etc.....

When i try to fill series it seems to only go 1.zip, 2.zip, 1.zip
2.zip etc..

thanks :confused
 
G

Gord Dibben

Rosco

In row 1 of any column enter

="ftp://anything/"&ROW()&".zip"

Drag/copy down as far as you need.

When happy with the returns, select the column and Copy>Paste Special(in
place)>Values>OK>Esc.

Gord Dibben Excel MVP
 
Top