Excel Guides

Getting Rid of Everything Except Numbers in Excel

If you're like most people, you probably have a lot of data in your Excel spreadsheet that isn't just numbers. Maybe you have text, dates, or other data mixed in with the numbers. Or maybe your cells are just formatted as text, even though they contain numbers. In either case, getting rid of everything except the numbers can be a pain. Here's a step-by-step guide to help you out:

  1. First, select the cells that you want to remove everything from except the numbers. You can do this by clicking on the cell and then dragging your mouse over the cells that you want to select. Or, you can click on the first cell, hold down the "Shift" key on your keyboard, and then click on the last cell. This will select all of the cells in between.
  2. Once you have the cells selected, go to the "Data" tab on the Excel ribbon and click on "Text to Columns".
  3. In the "Text to Columns" dialog box that appears, make sure that the "Delimited" option is selected and then click "Next".
  4. On the next page of the dialog box, make sure that all of the options are unchecked except for the one that says "Space". Then click "Finish".
  5. Excel will now split up your data into separate columns based on where there are spaces. So, if you had originally had three columns of data, you'll now have six columns. But don't worry, we'll fix that in a minute.
  6. Now that your data is in separate columns, we need to get rid of all of the columns that don't contain numbers. To do this, click on the header of each column that you want to delete and then press the "Delete" key on your keyboard. Repeat this until only the columns with numbers remain.
  7. Finally, we need to put our data back into three columns instead of six. To do this, select all of the cells in our three remaining columns and go back to the "Data" tab on the ribbon. This time, click on " Consolidate".
  8. In the "Consolidate" dialog box that appears, make sure that the "Sum" function is selected and then click "OK".
  9. You should now have all of your original data in three columns with only numbers!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.