Pasting HTML into the cells in column A

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Colin Hayes - 22 Jul 2006 19:55 GMT

Hi All

I'm trying to paste some HTML code from Front Page into the cells in
column A.

I copy the code in Front Page into Word. I copy this and highlight A1 in
excel. Then I open Paste Special and use copy HTML. I don't want Excel
to act on the code , just treat it as text. This is where the problem is

: the lines don't all go into column A , some go as far across as J! How

can I get them to only go down the rows in column A?

The HTML is stepped in shape and maybe that's the cause. I've tried left
justifying to no avail. I've been trying to paste this down the rows
exclusively in A for a long time now and am out of ideas now - can
anyone help? All appreciated.

Best Wishes

Colin

Reply to this Message

CIL - 23 Jul 2006 02:09 GMT

Good evening,
Not a very scientific answer and I don't know how or why it works but I on
occasion will paste the HTML into a sheet lets say sheet 1, it will show
the links, etc. Copy that information from that sheet and paste (paste
special7text)to another sheet "2" and it will be text and useable.

HTH.
cil

> Hi All
>
[quoted text clipped - 15 lines]
>
> Colin

Reply to this Message

CIL - 23 Jul 2006 02:12 GMT

special7text)to another sheet "2" and it will be text and useable.

oops;
should read "special / text) to another sheet "2" and it will be text with
no HTML."

> Good evening,
> Not a very scientific answer and I don't know how or why it works but I on
[quoted text clipped - 24 lines]
>>
>> Colin

Reply to this Message