Editing Easy methods to Split Cells into Rows or Columns

Microsoft Excel is a spreadsheet program that is standard with the Microsoft Office Suite. As a spreadsheet program, it is extremely useful for organizing information into different rows and columns. However, gathering data into the Excel spreadsheet can be a time-consuming process. As Excel functions using cells, typing information can be slow because the correct cell must be chosen each time information is entered. It can also make it challenging to edit the data within the Excel spreadsheet. Cutting, copying, and pasting can get puzzling in Excel due to all of the lines that appear around the data you are copying and where it is being pasted. One technique of [http://www.hothotsoftware.com/excel_split_and_breakapart_cells_software/ splitting data] within an Excel spreadsheet is through the use of formulas. Formulas are instructions that can be entered into a cell in a spreadsheet to generate a designated result. For example, if cell A1 contains the number 1 and cell A2 contains the number 2, then typing ‘ =SUM(A1:A2) ‘ in cell A3 will yield a result of 3. Similarly, transferring data can be done using formulas. Let's hypothetically visualize a scenario where a single sentence in a cell has been divided up word by word by commas. To list this text in a row with each word in a cell, first start by entering in the formula ‘ =INDEX(A:C,ROWS($1:3)/3,MOD(ROWS($1:1)-1,3)+1) ‘. This will present the data with each word in its own cell. There are additional formulas for ordering data in alternate formats. The problem arises in trying to memorize all the different formulas that allow for data rearrangement. A huge productivity boost is available through a simple stop at http://www.hothotsoftware.com/excel_split_and_breakapart_cells_software/. Simply looking for ‘How to Split Cells into Rows or Columns' yields a program specially created to fulfill your Excel file needs. The program is actually written to operate within the Excel spreadsheet program itself, also known as a plugin. This means that after starting Microsoft Excel, you will see the application displayed within a tab in the ribbon bar across the top of the Excel window. The tab that contains the plugin will say ‘Add-Ins'. The plugin will be shown as ‘Split Cells'. After choosing the plugin, a new window will appear. This window uses a classic user interface that allows even a basic computer user to learn and master the software in a short amount of time. This new window brings up the commands to split cells. First, choose which data you want to split. Then choose where you'd like the split data to appear. Then specify whether you would like to split the data into rows or columns. In the bottom half of the window are the options for dividers between the data. You can choose anything from a comma, tab, or a custom character. Then click the ‘Split Cells Now' button to start the process. To learn more about this software, please visit http://www.youtube.com/watch?v=hz7MDo6rSfE#t=23. Data listed in an Excel spreadsheet is very useful for organizing and moving data. Use this program to [http://www.hothotsoftware.com/excel_split_and_breakapart_cells_software/ rearrange that information] into an organized Excel spreadsheet.

| Editing help (opens in new window)