It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.

Microsoft Excel's "Text to Columns" feature lets you divide this data using two methods. If the data has an obvious deliminator, such as a comma between the last and first name, the "Delimited ...

Create a formula to add or subtract data in Excel by using cell numbers Above, we have seen a simple method to create a formula to add or subtract data in Excel.

Select the Data Column Select the first column containing data that you want to divide into columns. Excel's Convert Text to Columns Wizard works only on one column at a time.