How would I generate these webpages?

deranged_one_13 · Newbie Joined: 12 Jan 2007 Posts: 3

What I want to do is create a series of website links using a spreadsheet. In the first column I would have a series of 4 digit numbers, then in the second column I want to have a standard website address where the number from the first column can be inserted into...so:

0000 http://www.insertpagename.com/0000
0001 http://www.insertpagename.com/0001
0002 http://www.insertpagename.com/0002
...

How would I do this??

Ewald · OOo Advocate Joined: 16 Dec 2005 Posts: 392

enter the leading number in column A1 enter the webadress with the terminal forward slash in column B1. Then populate column C1 with =Concatenate(B1;A1). Column C1 should have your desired result

deranged_one_13 · Newbie Joined: 12 Jan 2007 Posts: 3

thank you! I knew there had to be a way to do it...I just wasn't sure what the function was called! Thanks again.

deranged_one_13 · Newbie Joined: 12 Jan 2007 Posts: 3

okay, another question:

Is there a way to quickly drag a column to increase numbers. For example, if I'm starting with 0000, and I want to go to 9999, is there a way to do that without dragging down all that way?

machinegun · General User Joined: 24 Mar 2005 Posts: 7

multiple ways to make huge selections Smile

{
select the starting cell, then use your mouse to scroll all the way down without selecting any other cell, then hold shift and select the last cell.
OR
there's this current location / selection on the left side of the formulae bar. type in your destination cell, go there, and do a control-shift + up. should bring you to the very top.
release control but hold on to shift and use arrow keys to "adjust" starting cell.
}

THEN

edit > fill > series
start value = 1
end value = [blank]
increment = 1

check result