Sorry for not stating my question fully. Let me try again.

I am copying a vertical column of information off of a web site. I need to
put the info into a spreadsheet horizontally instead of vertically. The info
contains blank spaces, "---------", Titles, Annotations, and URLs. I am
pasting it into 3 columns labeled Title, URL and Annotation. I've gone down
a couple cells and pasted special in the first column (title). In the second
column, I've gone up a couple spaces (so the first hyperlink is in the cell
next to title) and done a regular paste (to preserve the hyperlink). In the
third column, I've gone down an appropriate number of cells and pasted
special. This way, at least one of the first rows with info is correct.
Strip the rows above that and everything should be peachy, right? No. My
task now is a) to remove all the garbage (blanks and "---------" cells); b)
remove everything non-title from the title column; c) remove everything
non-annotation from the Annotation column; d) to remove everything non-title
from the Title column; e) remove all the non-hyperlinks from the URL column
and finally; f) get everything to line up.

Should work, right? Doesn't without a whole bunch of work. I can't delete
rows; I need to delete cells. I've gone to Go To special, but I can't delete
cells there, only rows. I've written a macro to delete selected cells and
move the others up, but it can only be done on about 5 cells at a time (then
I reach the info that needs to be retained).

I've tried to edit this sheet vertically and horizontally, and each time it
is a major pain. I'm just wondering if anyone has any insight into a better
way to do this. And I hope I've explained it clearer this time.

Thanks,
Bonnie


"Michael" wrote:

If I am correct in assuming that the data Title, Hyperlink and Description,
could be copied only once in Column A and would be in 3 rows, then you could
copy the 3 items and Paste Special - Transpose in Column B. That would
populate Columns B, C, and D with your data. To remove the word "Title:",
select the titles and do an Edit - Replace.
--
Sincerely, Michael Colvin


"gobonniego" wrote:

I've pasted the same info off a web page into three columns on a spreadsheet.
I neet to get a title, hyperlink and decription to go across the page, not
down. By pasting it three times, I just have to clean it up. (The titles
all say "Title:" in front of them.) But cleaning up is a real pain. Is it
possible to delete from the auto sort drop down box? (Or any other way?)
That way, in the third column, I could delete all the titles (since they only
go in the first column).