--- title: Split messy data into neat columns with Text to Columns description: Clean up data fast in Excel image: https://woodthorpeitsolutions.co.uk/hubfs/Portrait%20of%20a%20happy%20female%20student%20using%20laptop%20computer%20in%20university.jpeg --- [![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) # Split messy data into neat columns with Text to Columns [Woodthorpe IT](https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it) 20 January, 2026 ![](https://woodthorpeitsolutions.co.uk/hubfs/Portrait%20of%20a%20happy%20female%20student%20using%20laptop%20computer%20in%20university.jpeg) If you’ve ever been given a spreadsheet where names, dates, or codes are all squashed into one column, you’ll know how awkward it is to work with. Sorting, filtering, and analysing the data becomes almost impossible. Excel has a built-in tool that fixes this in seconds: **Text to Columns**. For example, you might have data like this in one column: John Smith – Sales – London ![Text-to-Columns-Excel](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Text-to-Columns-Excel.gif?width=357&height=227&name=Text-to-Columns-Excel.gif)To split this into separate columns: 1. Select the column with the messy data 2. Go to **Data → Text to Columns** 3. Choose **Delimited** and click **Next** 4. Tick the character that separates your data (for example **Comma**, **Space**, or **Dash**) 5. Click **Finish** Excel will instantly split the information into clean, separate columns — perfect for sorting, filtering, and reporting. This is ideal for: - Separating first names and surnames - Splitting postcodes or reference numbers - Breaking up imported data from other systems It’s a simple tool, but it can turn a messy spreadsheet into something usable in just a few clicks. Previous Post ###### [Clean Up Messy Text Fast](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-messy-text-fast) Next Post ###### [Select text in Word without dragging your mouse](https://woodthorpeitsolutions.co.uk/tips-and-news/select-text-in-word-without-dragging-your-mouse) ### Similar Blog Posts [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Happy%20person%20sitting%20Infront%20of%20a%20computer%20and%20looking%20relaxed%20cartoon-1.jpeg?width=352&name=Happy%20person%20sitting%20Infront%20of%20a%20computer%20and%20looking%20relaxed%20cartoon-1.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/drag-and-drop-in-outlook-you-have-the-power) #### [Drag and drop in Outlook - You have the power...](https://woodthorpeitsolutions.co.uk/tips-and-news/drag-and-drop-in-outlook-you-have-the-power) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Cartoon%20post%20it%20note%20with%20writing%20in%20it%20stuck%20on%20a%20computer%20screen.jpeg?width=352&name=Cartoon%20post%20it%20note%20with%20writing%20in%20it%20stuck%20on%20a%20computer%20screen.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/add-a-comment-to-a-cell-using-a-shortcut) #### [Add a comment to a cell using a shortcut](https://woodthorpeitsolutions.co.uk/tips-and-news/add-a-comment-to-a-cell-using-a-shortcut) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Lock%20your%20computer%20for%20security%20cartoon%20happy-1.jpeg?width=352&name=Lock%20your%20computer%20for%20security%20cartoon%20happy-1.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/lock-it-down-how-to-lock-your-computer-quickly) #### [Lock it down - How to lock your computer quickly](https://woodthorpeitsolutions.co.uk/tips-and-news/lock-it-down-how-to-lock-your-computer-quickly) [![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" : "2026-01-20T11:00:01.108Z", "datePublished" : "2026-01-20T11:00:01.000Z", "headline" : "Split messy data into neat columns with Text to Columns", "image" : [ "https://woodthorpeitsolutions.co.uk/hubfs/Portrait%20of%20a%20happy%20female%20student%20using%20laptop%20computer%20in%20university.jpeg" ], "mainEntityOfPage" : { "@id" : "https://woodthorpeitsolutions.co.uk/tips-and-news/split-messy-data-into-neat-columns-with-text-to-columns", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject" } } } ```