Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pasting HTML into the cells in column A
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pasting HTML into the cells in column A
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 "Colin Hayes" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pasting HTML into the cells in column A
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." "CIL" wrote in message news:m%zwg.13252$PO.11707@dukeread03... 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 "Colin Hayes" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |