When I paste some text from a browser into the Excel cell, it will copy the HTML format - colors, font type, sizes, into the cell as well. Is it possible to only copy&amp;paste the plain text into the Excel cell?
121006
I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when pasting into Excel?
58463
Does anyone know of an easy way to escape HTML from strings in ?  I need to be able to pass an arbitrary string and have it properly escaped for display in an HTML page (preventing JavaScript/HTML injection attacks).  I'm sure it's possible to extend jQuery to do this, but I don't know enough about the framework at the moment to accomplish this.
117043
Does anyone know how I can prevent the text in a table cell from wrapping?  This is for the header of a table, and the heading is a lot longer than the data under it, but I need it to display on only one line.  It is okay if the column is very wide.  The HTML of my (simplified) table looks like this:  &lt;table&gt;   &lt;thead&gt;     &lt;tr&gt;       &lt;th&gt;         &lt;div&gt;Really long column heading&lt;/div&gt;       &lt;/th&gt;       &lt;th&gt;         &lt;div&gt;Really long column heading&lt;/div&gt;       &lt;/th&gt;       &lt;th&gt;         &lt;div&gt;Really long column heading&lt;/div&gt;       &lt;/th&gt;       &lt;th&gt;         &lt;div&gt;Really long column heading&lt;/div&gt;       &lt;/th&gt;       &lt;th&gt;         &lt;div&gt;Really long column heading&lt;/div&gt;       &lt;/th&gt;       &lt;th&gt;         &lt;div&gt;Really long column heading&lt;/div&gt;       &lt;/th&gt;       &lt;th&gt;         &lt;div&gt;Really long column heading&lt;/div&gt;       &lt;/th&gt;     &lt;/tr&gt;   &lt;/thead&gt;   &lt;tbody&gt;     &lt;tr&gt;       &lt;td&gt;         &lt;div&gt;data&lt;/div&gt;       &lt;/td&gt;       &lt;td&gt;         &lt;div&gt;data&lt;/div&gt;       &lt;/td&gt;       &lt;td&gt;         &lt;div&gt;data&lt;/div&gt;       &lt;/td&gt;       &lt;td&gt;         &lt;div&gt;data&lt;/div&gt;       &lt;/td&gt;       &lt;td&gt;         &lt;div&gt;data&lt;/div&gt;       &lt;/td&gt;       &lt;td&gt;         &lt;div&gt;data&lt;/div&gt;       &lt;/td&gt;       &lt;td&gt;         &lt;div&gt;data&lt;/div&gt;       &lt;/td&gt;     &lt;/tr&gt;   &lt;/tbody&gt; &lt;/table&gt;   The heading itself is wrapped in a div inside the th tag for reasons pertaining to the javascript on the page.    The table is coming out with the headings wrapping onto multiple lines.  This seems to only happen when the table is sufficiently wide, as the browser is trying to avoid horizontal scrolling.  In my case, though, I want horizontal scrolling.  Any ideas?
35150
I have the following annoying problem with Excel 2010. I use Conditional formatting to apply bold formatting to each line of the spreadsheet that meets a condition expressed by a formula. In the "applies to", I write =$A$2:$Q$149, which is the current extent of my spreadsheet. But I want this range to grow with my spreadsheet, i.e., I want the formatting to permanently apply to the whole spreadsheet. Regularly, my "applies to" field is transformed into a complex range, that selects most lines of spreadsheet, but not all, like =$A$2:$Q$138;$A$140:$Q$147. Have you ever encountered such a problem? Is there a solution?
85526
Are there any lists of default CSS stylesheets for different browsers? (browser stylesheets in tabular form)  I want to know the default font of text areas across all browsers for future reference.
99614
I tried Libreoffice, but its Import option while pasting in the cell is very  annoying.I also tried Gnumeric but I am not able to paste using middle button.Parcellite to make copy paste faster and middle button pasting is not working with Gnumeric. Is there any simple table maker app available that can accept only simple unformatted text? All these software are very complicated for this simple work.
18762
I'd like to extract the text from an HTML file using Python.  I want essentially the same output I would get if I copied the text from a browser and pasted it into notepad.    I'd like something more robust than using regular expressions that may fail on poorly formed HTML.  I've seen many people recommend Beautiful Soup, but I've had a few problems using it.  For one, it picked up unwanted text, such as JavaScript source.  Also, it did not interpret HTML entities.  For example, I would expect &amp;#39; in HTML source to be converted to an apostrophe in text, just as if I'd pasted the browser content into notepad.  Update html2text looks promising. It handles HTML entities correctly and ignores JavaScript.  However, it does not exactly produce plain text; it produces markdown that would then have to be turned into plain text. It comes with no examples or documentation, but the code looks clean.    Related questions:
55286
I have lots of cells that contain unique text.   I'd like to add a &lt;p&gt; to the start of the cell and a &lt;/p&gt; to the end of the string in the cell.   Turning this: Here is some text I've written. It's different in each cell. into this: &lt;p&gt;Here is some text I've written. It's different in each cell.&lt;/p&gt;  I've tried =CONCATENATE("&lt;p&gt;",A1) but can't find a way to add something to the end of the cell as well?
108153
I'm making a list in Excel where many rows have the same data in a number of columns, enough so that I'd like to hit Ctrl-C once on this set of common data, and then just hit Ctrl-V every time I make a new row that has those attributes.    The problem is, after I paste one time using Ctrl-V, and then go to type in the header for the next row, Excel, removes that information from the clipboard, so if I want to copy it again, I have to select it and hit Ctrl-C again.    I can work around this by pasting the data into Notepad as a tabbed list, then copy from Notepad using Ctrl-C.  This way, the clipboard is managed by Windows, not hijacked by Excel.    Is there an option or some other way to copy/paste so that Excel won't empty the clipboard contents even if I type between pastes?
101221
Is there anything in a custom formatted formula which defines the text alignment?  I know the different parts of the formula is numbers, negative numbers and so on, but I need to set the alignment.  Example:  _*# ##0_;_*(# ##0)_;_*"-"??_;_@_
32805
Using Excel for Mac 16.40 &amp; Illustrator 24.2.3, when I copy a graph from Excel to Illustrator, all the text corrupts:  The text font is Arial. It would be so nice if Excel graph text copied and pasted into Illustrator without being corrupted. Is it possible to copy/paste/import Excel graphs into Illustrator with the text being retained? Help appreciated.
48545
How can certain programs set background and font colors, write characters to the same location on screen (e.g. to the third row, fifth column) more than once?  Some examples are the progress bar displayed by curl google.com &gt; a, some installation screens and nearly any text editor.
66486
Steps to reproduce:   Write something in  Copy that text Try pasting in Stack Overflow It opens the image upload dialog box (Example: )   PS: I tried pasting the same in the  editor, and it pasted the text properly.  OS Version: Windows&nbsp;10  I tested and replicated it on the following two browsers:   Chrome: Version 77.0.3865.90 (Official Build) (64-bit) Edge: Microsoft Edge 42.17134.1.0
108217
Is there a way for a link to be copied with the selected text?  "Some selected text with this  somewhere in the paragraph"  To be copied as:  "Some selected text with this { link |  } somewhere in the paragraph"  If there is anything like that it would be great help.
73620
How can I prevent the contents of specific cells (or entire row or column) from printing in Excel, while keeping them visible on the screen when I'm editing the file? Ideally I should be able to do this to cells in the interior of the spreadsheet (i.e., not just the rightmost column(s) or the bottom row(s)). Hiding row(s) or column(s) is not acceptable because I need to maintain the cell size, to maintain the overall appearance of the sheet.  I've looked for a way to define a conditional format that's conditional on whether Excel is currently printing, but there doesn't seem to be any such thing. I've been manually setting the text color to white before printing (and manually reverting it afterwards), but it seems there should be an automagic way of doing this.
80165
How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser?  I pasted 100 urls and each went into its own cell. When I double-click in the cell and then leave it, Excel turns the text blue and makes a link out of it. I don't want to double-click a hundred times, but still want to format all the cells into links.
38948
When I copy text out of a PDF file and into a text editor, it ends up mangled in a variety of ways. Formatting like bold and italics are lost; soft line breaks within a paragraph of text are converted to hard line breaks; dashes to break a word over two lines are preserved even when they shouldn't be; and single and double quotes are replaced with ? signs.  Ideally, I'd like to be able to copy text from a PDF and have formatting converted to HTML codes, "smart quotes" converted to &quot; and &apos;, and line breaks done properly. Is there any way to do this?