Using html in excel

fullthrottlecb

New Member
Joined
Mar 10, 2011
Messages
5
I want to edit html in excel. I copy the html into excel and it displays as a web page. How do i just keep as text.

Thanks
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
You could double click in a cell, then paste. Or open a textbox and work in the textbox, which will be a little easier to get around in. Though I can't see why you'd want to use Excel as an HTML editor. Use a real text editor. My favorite is Notepad++. It's free (as in beer and speech). You get with it keyword highlighting, tag matching, auto indenting, collapsible outlines, and quite a lot more.
 
Last edited:
Upvote 0
What do you mean when say
...I copy the html into excel...

If you want just want the html you right-click on the web page and select view page source, then select all, copy and paste in excel. When I do that I get the text only. Is that what you are doing?

But I have to agree with xenou using excel as an html editor is probably not the way to go. I use notepad++ too and it makes editing html a lot easier.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,595
Messages
6,179,799
Members
452,943
Latest member
Newbie4296

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top