--- title: Larilyn's Tip of the Week:  Microsoft Excel - Cell Data to Separate Columns description: Cell Data to Separate Columns image: https://www.inmotionnet.com/hubfs/steve-urkel-going.gif --- [Skip to content](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns#main-content) [Contact us](https://www.inmotionnet.com/contact) ![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png) - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) Open main navigation Close main navigation - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Contact us](https://www.inmotionnet.com/contact) Feb 17, 2022 4:30:00 AM # Larilyn's Tip of the Week:  Microsoft Excel - Cell Data to Separate Columns [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Share: [facebook-f icon](http://www.facebook.com/share.php?u=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns) [linkedin-in icon](http://www.linkedin.com/shareArticle?mini=true&url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns) [Twitter icon](https://twitter.com/intent/tweet?url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns) [pinterest-p icon](http://pinterest.com/pin/create/link/?url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns) [envelope icon](mailto:?body=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns) One of the best things about Excel is how many ways there is to manipulate data.  Exported data is great, but the way that it is formatted doesn't always work for you.  You don't have to keep it the way that it comes.  You don't have to take it! ![steve-urkel-going](https://www.inmotionnet.com/hs-fs/hubfs/steve-urkel-going.gif?width=360&name=steve-urkel-going.gif)  For example, a lot of times there will be one column with information that you'd rather have split between two columns, such as a name.  You may want a column for first names and a column for last names.  And it couldn't be simpler! ![simple-big](https://www.inmotionnet.com/hs-fs/hubfs/simple-big.jpg?width=294&name=simple-big.jpg)   So you start with the column, like so.   ![listof names](https://www.inmotionnet.com/hs-fs/hubfs/listof%20names.png?width=502&name=listof%20names.png) Next you want to highlight the data you want to split and then you go the Data tab of the menu and select Text to Columns. ![Data text to columns](https://www.inmotionnet.com/hs-fs/hubfs/Data%20text%20to%20columns.png?width=1284&name=Data%20text%20to%20columns.png) This is going to open up a Wizard, which is simple to complete.  On the first step, you will choose that the data is delimited and click next.. ![wizard 1](https://www.inmotionnet.com/hs-fs/hubfs/wizard%201.png?width=546&name=wizard%201.png) In this example, the text we want to split is separated by a space between the first and last name, So in the next step, we want to tell the wizard that the delimiter is Space and click next. ![wizard 2](https://www.inmotionnet.com/hs-fs/hubfs/wizard%202.png?width=499&name=wizard%202.png) In the final box, we are telling the Wizard where to put the newly split data.  I want to keep the original column in place, so I'm telling the Wizard to put the split data starting in Column B, cell 2.  But if you want to get rid of the first column all together, you can have it start in Column A.  Or Column Z.  Customize as you wish! ![wizard 3](https://www.inmotionnet.com/hs-fs/hubfs/wizard%203.png?width=511&name=wizard%203.png) Click Finish, and you have your names split just as you like them! ![finished](https://www.inmotionnet.com/hs-fs/hubfs/finished.png?width=529&name=finished.png) Happy manipulating!  Of data.  Just data.  Not people or anything...... [Excel](https://www.inmotionnet.com/blog/tag/excel) ## Related posts [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized) ## [Larilyn’s Tip of the Week: Consent Phishing](https://www.inmotionnet.com/blog/2021/08/larilyns-tip-of-the-week-consent-phishing) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Aug 18, 2021 9:30:00 PM When it comes to technology, there are two things that are certain: [Read more](https://www.inmotionnet.com/blog/2021/08/larilyns-tip-of-the-week-consent-phishing) [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized) ## [Larilyn’s Tip of the Week: Christmas](https://www.inmotionnet.com/blog/2020/12/larilyns-tip-of-the-week-christmas) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Dec 21, 2020 1:00:00 AM This week we’re all about Christmas, so I’m going to give you a tip that will hopefully help you... [Read more](https://www.inmotionnet.com/blog/2020/12/larilyns-tip-of-the-week-christmas) [![](https://www.inmotionnet.com/hs-fs/hubfs/Happy%20young%20woman%20sitting%20on%20the%20floor%20with%20crossed%20legs%20and%20using%20laptop%20on%20gray%20background.jpeg?height=200&name=Happy%20young%20woman%20sitting%20on%20the%20floor%20with%20crossed%20legs%20and%20using%20laptop%20on%20gray%20background.jpeg)](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-embracing-chatgpt) [Computers](https://www.inmotionnet.com/blog/tag/computers), [Technology](https://www.inmotionnet.com/blog/tag/technology), [ChatGPT](https://www.inmotionnet.com/blog/tag/chatgpt), [ChatGPTatWork](https://www.inmotionnet.com/blog/tag/chatgptatwork), [AI](https://www.inmotionnet.com/blog/tag/ai), [AIEthics](https://www.inmotionnet.com/blog/tag/aiethics), [AITrends](https://www.inmotionnet.com/blog/tag/aitrends) ## [Larilyn's Tip of the Week:   Embracing ChatGPT](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-embracing-chatgpt) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) May 23, 2024 4:30:00 AM I currently work on a University campus, and with that comes a lot of talk about how AI and... [Read more](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-embracing-chatgpt) [![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png)](https://inmotionnet.com) 24930 Washington Ave Unit #157 Murrieta, CA  92564 (951) 894-8809 This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. - [Home](https://www.inmotionnet.com) - [Blog](https://www.inmotionnet.com/blog) - [Contact](https://www.inmotionnet.com/contact) - Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Privacy](https://www.inmotionnet.com/privacy-policy) - [Terms](https://www.inmotionnet.com/terms-of-service) --- [linkedin-in icon](https://www.linkedin.com/company/in-motion-networks-corporation/) [Twitter icon](https://twitter.com/InMotionNet/) [facebook-f icon](https://www.facebook.com/inmotionnet/) Copyright © 2026, In Motion Networks Corporation ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Larilyn Holt", "url" : "https://www.inmotionnet.com/blog/author/larilyn-holt" }, "dateModified" : "2022-02-17T12:30:00.581Z", "datePublished" : "2022-02-17T12:30:00.000Z", "headline" : "Larilyn's Tip of the Week:  Microsoft Excel - Cell Data to Separate Columns", "image" : [ "https://www.inmotionnet.com/hubfs/steve-urkel-going.gif" ], "mainEntityOfPage" : { "@id" : "https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.inmotionnet.com/hubfs/InMotionLogoNEW_RGB%20copy.png" }, "name" : "In Motion Networks" } } ```