Data in Excel 365 2016 2013 2010 2007

Splitting text strings without using formulas

If you want to paste text in your worksheet, you can use Excel's Convert Text to Columns Wizard.

Creating Subtotals

Excel's ability to create automatic subtotals is a handy feature that can save you a great deal of time.