How to Split Cells in Excel with Text to Columns - Excel Tutorial
Excel tutorial on how to split the contents of cells in Excel using Text to Columns.
Using Text to Columns, you have 2 options for how you can split the cell data. You can choose Delimited or Fixed Width.
Fixed Width adds splits in the same spot in all the cells selected and is ideal for separating content that has all the same number of characters.
When you use Delimited to separate cells, you can select 1 or more delimiters (spaces, comma, semicolon, etc) for which to separate your cells at. This is ideal for separating content that varies in length, like names, and in which all the cells in your selection share a common delimiter.
And make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
