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
2007-07-31
17:57:47
·
3 answers
·
asked by
Anonymous
in
Software