Text Cleaner: Clean text using online Text Cleaner. An all-in-one text cleaning and text formatting online tool that can perform many simple and complex text operations including remove line breaks, strip HTML, and find and replace text online.
A solution: this script converts text copied from MS word into plain text. Paste your input into the top box, press clean, and the input will be scrubbed and sent to the lower box. (If you want to clean up Word HTML, rather than just create plain text, I suggest that you use HTML Tidy with the “clean” and “Word 2000” boxes checked.). CLEAN(text) The CLEAN function syntax has the following arguments: Text Required. Any worksheet information from which you want to remove nonprintable characters. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
Settings
Clean Text
Whitespace
OtherHTMLLinksText Formatting
Letter caseClean Text Menu
QuotesDuplicatesTrimWritingFind and Replace
About
What is Text Cleaner?
Text Cleaner or Clean Text is an all-in-one online text cleaning and text formatting tool that can perform many complex text operations. With this, you can also create your very own 'find and replace text online' list. It can remove unnecessary spaces and unwanted characters. It can also change letter case, convert typographyquotes, delete duplicate lines/paragraphs and words, convert bold and italic unicode letters into regular letters, fix spacing between punctuations, remove letter accents, decode character entity codes, unescape andstrip HTML tags, convert urls to links, and more.
It's highly-customizable. You can tweak the settings based on your personal preference. Your custom configuration is automatically saved in your browser, so you don't have to completely redo your settings on your nextvisit.
The main purpose of this utility is to unformat a formatted text and remove all unmeaningful characters which are often present in texts that were copied directly from word processors, web pages, PDFs, client briefs, ande-mails. I originally made this tool for my first data entry job and it made my work easier. I hope you find it useful too. This web app is free to use for any individual, company, office or organization for research,development, and/or commercial purposes. Please back up your data accordingly. We will not be held legally liable for any data loss which may occur while performing work on your computer.
How to use?
Remove Text Online
Simply copy and paste your text in the input box, configure the settings below by checking/unchecking the boxes and click the clean button. The cleaned version of your text shoulded appear in the result box. Notexpecting the result you wanted? No worries, you can go back and click the input tab and from there you can start from the top. Hitting the reset button will clear both fields.
Useful Tools
- Comma Separator Delimiter - Online Comma Separator tool to delimited values. Online Delimiter tool supports comma, semicolan, pipe, space and all custom characters.
- HTML to Text Converter Online - Convert HTML code to plain text with this online tool. It will strip all HTML tags, remove line breaks and clean empty white space.
- Word Counter - Use this Word Counter Online tool to easily count words, characters, Characters without spaces, Sentences, Paragraphs and total lines of your text.
- Character Count - Character Count Online is an online tool that lets you easily calculate and count the number of characters, words, sentences and paragraphs in your text.
- Find and Replace - Find and Replace Text Online with our find and replace online tool. It also supports regular expressions.
- Diff Checker - Use Diff checker Online tool to compare text to find the difference between two text files. It is very useful when comparing the old and the new version of your text document to find text difference and similarities.
- FAQ Schema Generator - #1 JSON-LD Schema Generator tool to generate FAQ Schema. Simply add Frequently asked questions and answers to get FAQPage schema code.
- Remove line breaks - Remove line breaks online from text or word document but preserve paragraph breaks. You can also replace line breaks with a character of your choice with this tool.
- Add line breaks - Add line breaks from text or word document. You can add line breaks online with specific word/ character or after an occurrence of a letter/word.
- Morse Code Translator - Convert Text to Morse code and vice versa with Audio play and download sound.
- Online Notepad - Browser-based text editor. A simple online tool that makes taking down notes easier and more convenient.
- Text Tools - A collection of web-based text processing tools that will help you automate the recurring tasks of editing and formatting blocks of text.
This is a repost of an entry from 2004. This Word-cleaning functionality is showing up in more and more web editors, but people might still find this useful.
Most of the time when I’m writing content for the web (for this blog, or a forum comment, or whatever), I’ll write in Microsoft Word for the spell check and other features that aren’t in a standard textarea widget, and then I’ll cut and paste into the form on the site.
The problem is that this carries all of the high characters (“smart-quotes” and the like) that MS Word makes straight through to the site — and most sites aren’t set up to handle them. They expect plain (“Latin”) text.
A solution: this script converts text copied from MS word into plain text. Paste your input into the top box, press clean, and the input will be scrubbed and sent to the lower box.
(If you want to clean up Word HTML, rather than just create plain text, I suggest that you use HTML Tidy with the “clean” and “Word 2000” boxes checked.)
Web Developers: feel free to use this code on your own forms to clean your user’s input (although you’d probably be better off doing it server-side). Just change the onClick() method to convert the text inplace.