Merged cells and hyperlinks

[Delbert Waltrip]

I copied 250 rows of single column text from a downloaded file.
Also, when I place the cursor on any of the lines, it is hyperlinked.
How do I find the merged cells, or better yet, how to I remove all the merge
function from the whole worksheet?
How do I remove the hyperlink function from all of this text?

 

[Dave Peterson]

with that worksheet the activeworksheet:

Hit alt-f11 (where macros live)
hit ctrl-g (to see the immediate window)
type this and hit enter:
activesheet.cells.mergecells=false

Then type this and hit enter:
activesheet.hyperlinks.delete

Then back to your worksheet.

 

[Selvarathinam]

Dear Delbert,

Select all the 250 rows & move to new sheet of the same file or create
a new file and use "paste special" option by right click in the mouse &
select "values" & click OK.

All the information will be copied without hyperlink & merged cells.

Hope the above solution will help u.

Regads,
Selvarathinam.

 

[Delbert Waltrip]

That did the job. Thanks.
Del