--- title: Clean Up Messy Text Fast description: Clean up messy text in Excel with quick formulas like TRIM, PROPER, and CLEAN to remove extra spaces, capitalise words, and delete hidden characters. image: https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20clean%20modern%20workspace%20with%20a%20sleek%20laptop%20open%20to%20an%20Excel%20spreadsheet%20displaying%20a%20list%20of%20text%20entries%20The%20cells%20contain%20vario.png --- [![logo](https://woodthorpeitsolutions.co.uk/hubfs/logo.png)](https://woodthorpeitsolutions.co.uk) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) [0800 044 3779](tel://08000443779) [Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/excel) # Clean Up Messy Text Fast [Woodthorpe IT](https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it) 16 December, 2025 ![](https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20clean%20modern%20workspace%20with%20a%20sleek%20laptop%20open%20to%20an%20Excel%20spreadsheet%20displaying%20a%20list%20of%20text%20entries%20The%20cells%20contain%20vario.png) If your imported text looks odd, Excel has clean-up formulas that fix it in seconds: - **=TRIM(A1)** removes extra spaces. - **=PROPER(A1)** capitalises the first letter of each word. - **=CLEAN(A1)** deletes hidden or non-printable characters. Use them in a new column, then copy and paste the cleaned results as values. 👉If you want to update the original data, copy the formula result and use "Paste Special" > "Values" to paste over the top of the original. Previous Post ###### [Quick Totals Without Formulas](https://woodthorpeitsolutions.co.uk/tips-and-news/quick-totals-without-formulas) Next Post ###### [Split messy data into neat columns with Text to Columns](https://woodthorpeitsolutions.co.uk/tips-and-news/split-messy-data-into-neat-columns-with-text-to-columns) ### Similar Blog Posts [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Portrait%20of%20a%20happy%20female%20student%20using%20laptop%20computer%20in%20university.jpeg?width=352&name=Portrait%20of%20a%20happy%20female%20student%20using%20laptop%20computer%20in%20university.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/split-messy-data-into-neat-columns-with-text-to-columns) #### [Split messy data into neat columns with Text to Columns](https://woodthorpeitsolutions.co.uk/tips-and-news/split-messy-data-into-neat-columns-with-text-to-columns) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Stock%20Images/hazel-z-FocSgUZ10JM-unsplash.jpg?width=352&name=hazel-z-FocSgUZ10JM-unsplash.jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-data-fast-with-find-replace) #### [Clean up data fast with Find & Replace](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-data-fast-with-find-replace) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/thisisengineering-uyfohHiTxho-unsplash.jpg?width=352&name=thisisengineering-uyfohHiTxho-unsplash.jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/select-text-in-word-without-dragging-your-mouse) #### [Select text in Word without dragging your mouse](https://woodthorpeitsolutions.co.uk/tips-and-news/select-text-in-word-without-dragging-your-mouse) [![Logo 290x70 - white](https://woodthorpeitsolutions.co.uk/hubfs/Logo%20290x70%20-%20white.png)](https://woodthorpeitsolutions.co.uk) Woodthorpe IT Solutions are providers of Microsoft 365 training and consultancy.  Established in 2005 we have trained over 10k people and continue to help learners get the most from their computer. [Want to resell our courses?  Click here to learn more.](https://woodthorpeitsolutions.co.uk/reseller) [Follow us on LinkedIn](https://www.linkedin.com/company/woodthorpe-it-solutions/) [Follow us on YouTube](https://www.youtube.com/@WoodthorpeITSolutionsLtdBlacon) ###### Get In Touch 0800 044 3779 contactus@woodthorpeit.com ##### Company details Co number: 05572129 Vat number: 936 2824 09 ##### Trust [Privacy Notice](https://woodthorpeitsolutions.co.uk/privacy-notice) [Terms](https://woodthorpeitsolutions.co.uk/terms) [Slavery and Human Trafficking Statement](https://woodthorpeitsolutions.co.uk/slavery-and-human-trafficking-statement) Copyright © 2026 Woodthorpe IT Solutions Limited ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Woodthorpe IT", "url" : "https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it" }, "dateModified" : "2025-12-16T11:00:01.021Z", "datePublished" : "2025-12-16T11:00:01.000Z", "headline" : "Clean Up Messy Text Fast", "image" : [ "https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20clean%20modern%20workspace%20with%20a%20sleek%20laptop%20open%20to%20an%20Excel%20spreadsheet%20displaying%20a%20list%20of%20text%20entries%20The%20cells%20contain%20vario.png" ], "mainEntityOfPage" : { "@id" : "https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-messy-text-fast", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject" } } } ```