Skip to content

Excel AutoComplete Suggestions From Lists by Oheen

Best Excel AutoComplete Suggestions Tool

X
  • Contact
Menu

How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016)

Posted on November 10, 2017May 15, 2019 by exceladmin

Sometimes you have a big list containing words and number. You wonder how would you get just the words (or numbers). If you do this by hand, it would take a lot of time if your list is big (100+ items or more). The task will be come tedious if you have thousands of them. Luckily, Excel comes to the rescue. With simple steps, you can filter the Numbers from the list and get the list with just words.

So, for example, I have this list:

Excel tools

2010

Words

MS Office

1230

…

The list can go on and on.

a sample excel list
a sample excel list

Now, our task would be removing 2010 and 1230 out of the list.

What you need to do is to select that column A, go to Data->Filter

using excel filter
using excel filter

Now, you will see an arrow point down appears and the top of the column, click on that, click on custom filter as below:

 

custom filter

Now, you will a new window appears like this:

Now, the trick is to select the filter condition to be is greater than (or is less than, if you prefer) and enter number 0 into the box on the right. You will see that all boxes contain any character from a to z will be hidden.

Now, you only need to delete the rows that left and click on the filter button again to get all the rows that don’t contain numbers.

So, that’s a simple trick that help you filter out the cells that contain numbers in a list that has both numbers and text. I hope the trick has been useful. Please subscribe for more Excel tips and tricks.

Just a reminder, if you need to enter a large list, you can always use our excel autocomplete tool . It will save you time and make data entry much easier.

 

Posted in Excel tipsTagged excel filter nubmer, excel tips

Post navigation

How To Turn Excel Into CSV With UTF-8 Support

Related Post

  • How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016) How To Check If Multiple Conditions Are Met In Excel
  • How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016) How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016…
  • How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016) How To Extract Parts of Date In Excel
  • How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016) How To Count Number Of Days, Years, Months… Between Two Dates In Excel
  • How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016) How To Extract Parts Of Text String
  • How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016) How To Remove Leading And Trailing Space From Text String In Excel
  • How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016) Excel Tip 2: How To Move To The Beginning And The End of The Data Table In Excel
  • How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016) Excel Tips 1: Double Click To Copy Formula
  • How To Filter Numbers Out Of A List Using Excel (Working With 2003, 2007, 2010, 2013, 2016) How to include double quotes in Excel formulas?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Contact Support

If you need support, please click below

Recent Posts

  • How To Check If Multiple Conditions Are Met In Excel
  • How To Check to See Whether a Simple Condition Is Met In Excel 2007, 2010, 2013, 2016…
  • How To Extract Parts of Date In Excel
  • How To Count Number Of Days, Years, Months… Between Two Dates In Excel
  • How To Extract Parts Of Text String
  • How To Remove Leading And Trailing Space From Text String In Excel
  • Excel Tip 2: How To Move To The Beginning And The End of The Data Table In Excel
  • Excel Tips 1: Double Click To Copy Formula
  • How to include double quotes in Excel formulas?
  • How To Turn Excel Into CSV With UTF-8 Support
Theme Design & Developed By OpenSumo
  • Contact
  • Excel Autocomplete From List