Show Have you ever tried to split a sentence into separate words, and place each word in a single cell? Here I tell you the tricks to quickly break a sentence into
separate cells by words in Excel. Split sentence into separate words with Text to Column function Split sentence into separate words with Kutools for Excel Split sentence into separate words with Text to Column functionThere is a function called Text to Columns in Excel which can help you handle it. 1. Select the sentences you want to break into words, and click Data > Text to Columns. See screenshot: 2. In the step 1 of Text to Columns wizard, check Delimited option, and click Next to go on. See screenshot: 3. In the step 2 of the wizard, check Space in the Delimiters section. See
screenshot: 4. Click Next to go to the last step of the wizard, and select a cell to place the separate words. See screenshot: 5.
Click Finish, and the selected sentences have been broken into words in separate cells. Split sentence into separate words with Kutools for ExcelWith Text to Columns function, the steps of wizard are a little complex, but with Kutools for Excel’s Split Cells utility, the operations will be much easier. After free installing Kutools for Excel, please do as below: 1. Select the sentence cells, and click Kutools > Merge & Split > Split Cells. See
screenshot: 2. In the Split Cells dialog, check the split type you need in the Type section, and the check Space in the Split by section. See
screenshot: 3. Click Ok, select a cell to output the split cells in the popping dialog, and the click OK to finish. See screenshot: After that, the sentences have been split into separate words. Click here to know more about Split Cells. Relative Articles:
The Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Comments (1) No ratings yet. Be the first to rate! What is the shortcut to separate text in Excel?To Separate Text in Excel, we can use the Text to Column option, which is available in the Data menu tab under Data Tools. We can also use this option with short cut keys ALT + A + E simultaneously once we select the data which we want to separate.
How do I isolate part of text in Excel?Depending on where you want to start extraction, use one of these formulas: LEFT function - to extract a substring from the left. RIGHT function - to extract text from the right. MID function - to extract a substring from the middle of a text string, starting at the point you specify.
How do I separate text in a spreadsheet?Split data into columns. On your computer, open a spreadsheet in Google Sheets. ... . At the top, click Data. ... . To change which character Sheets uses to split the data, next to "Separator" click the dropdown menu.. To fix how your columns spread out after you split your text, click the menu next to "Separator". |