[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

Options for pasting HTML into Excel

Hello,

When pasting a block of HTML into Excel, it sometimes displays the actual HTML (what was pasted) but other times, it displays what the HTML codes for.

What accounts for the difference in how it's displayed?

Is there a setting in Excel to control which of the two forms is displayed?

Thanks
0
WeThotUWasAToad
Asked:
WeThotUWasAToad
2 Solutions
 
rspahitzCommented:
I haven't seen this but...
1) Maybe it's pasted into a Text field rather than a General field?
2) I've noticed that different browsers paste will produce different results when putting them into Excel.  For example, copy a page from Chrome and paste; some parts will look different if copied from Firefox and pasted or IE and pasted.

Do you have an example (public) page that we can try?
0
 
ThomasMcA2Commented:
When you want to get just the raw HTML, use Paste Special to paste only the text.

Do all of your paste attempts have a begin tag (<something>) and a matching end tag (</something>)?
0
 
WeThotUWasAToadAuthor Commented:
Thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now