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.

*FYI:

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 😊

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

[chrisstyles]

Text spliting in excel is messed up. While there is an existing text join formular, they ought to be a co-existing text split formular; honestly excel is a stupid software for this costly mistake. And worst of all, microsoft excel in android doesn't have so many key features which are availavle in the desktop version. Text to coloumn wizard (used for text splitting under data tab) is one of those missing key features. The use of this type of formular =LEFT(A2, SEARCH("-", A2, 1)-1) for text splitting is silly and nonsensical. Let us say you have a derived value from somewhere (or something of that nature) which you want to split. Atimes it may return two joined words, three joined words or four joined words. Since you must know the exact number of joined words using this stupid formular, how do you do this without using text to coloumn wizard in data tab?