Help with excel 2003 needed pls?

Question

I have a column of cells, each row is filled with a url.

In the first row, the cell looks like www.domain.com/name/a.html

In the second row, the cell looks like www.domain.com/name/b.html

I need 26 rows so that row 3 ends in /c.html, row 4 ends in /d.html, all the way to row 26 which ends in /z.html

I highlighted the first two cells and then dragged the mouse, hoping it would autofill, but it didn't work correctly.

If it was just one column of data, I would do it manually, but I have about a large number of columns that follow the same pattern and would really appreciate any help I could get to speed up the process.

Thank you

Answer 1

use the concatenate function. It combines texts.
For example.
First in a separate column type a,b,c,d,......z.
Go to insert - functions - concatenate
in the first box type or select "www.domain.com/name/"
in the second box, just select the letter you want. (they should be in order)
in the 3rd box, type ".html"

Thats all

Even the following formula will do.
="www.domain.com/name/"&A1&".html"
where A1 is the letter.

Answer 2

You can create a custom list for the a.html, b.html part of the formula. Then copy the domain name info and paste it into each cell. Or you can use the concatenate function with the domain names in a different column.

to create a custom list:


In a blank new worksheet make the list in a series of cells and highlight it.
Tools Menu -> Options
Click the Custom Lists tab
The dialog box should have the highlighted cell references in the bottom box.
Click "Import".
Values should show in right window.
Click Okay. Done

In any worksheet cell type a.html then use the fill handle to drag down with all the values.

Answer 3

i dont quite get u..but i tell excel 2003 is easy to work with..try add in more details maybe then i can help u.