Paste HTML into an excel cell

Cd1986 · 14 Feb 2012 at 19:26

I have a block of HTML that I need to paste into HTML so that the actual code remains in the cell. The code I have is a formatted table containing text and images but when I paste the code into a cell, the actual table appears in excel, not the code.

I need to be able to paste the entire code into one cell to form part of a csv upload file.

Any help would be much appreciated

lolism · 14 Feb 2012 at 23:38

Save the html as a .txt file and open it in MS Excel, choose Delimited then untick all delimiters, save as CSV.
bit of a pain, but it works.

Pho · 14 Feb 2012 at 23:59

Try pasting the HTML into the formula bar not the cell its-self (i.e. select the cell, click the formula bar, paste, rejoice).

Cd1986 · 15 Feb 2012 at 10:38

thanks for the replies. Pasting into the formula bar seems to strip some of the formatting out. Saving as a .txt and then opening in Excel seems to work but i need all the code to be in the same cell.

Presumably, if i edit the .txt file so everything is on the same line, that should do the trick.

BaJ · 15 Feb 2012 at 12:41

What about trying the options under 'Paste Special'?

lolism · 15 Feb 2012 at 13:34

Cd1986 said:
thanks for the replies. Pasting into the formula bar seems to strip some of the formatting out. Saving as a .txt and then opening in Excel seems to work but i need all the code to be in the same cell.

Presumably, if i edit the .txt file so everything is on the same line, that should do the trick.

It will indeed, is it a lot of code?

Cd1986 · 15 Feb 2012 at 19:18

All sorted. Save as a txt file and rearrange the code so it is all on the top line