There is probably a better way of doing what you want to do. Do you have MS
Explorer on your system? If you can open this browser and navigate to the
web site of interest, right-click on the field that you want in Excel and
click 'Export to Microsoft Excel'. That will import the data you want and
you won't have to deal with those annoying formatting issues, such as merged
cells.

Regards,
Ryan---

--
RyGuy


"JE" wrote:

I copied and pasted from an HTML page several columns of information. When
it pasted into Excel, it merged several cells together. I want to remove the
merge so that I can manipulate the data. Is there a way to highlight the
entire spreadsheet and remove the merge? Many thanks.