filter

  • Thread starter Thread starter kirkcwn
  • Start date Start date
K

kirkcwn

how to filter a column that some cells are numbers, some cells are English
word, some cells content non-English word. thank you
 
Hi,

Select the column and go to Data - Filter - AutoFilter. Click the dropdown
arrow and select (Custom). Custom AutoFilter box will appear. Under the
Show rows where, select "equals" by clicking the dropdown arrow. On the
right side put a *, then the non numerical cells will be filtered. If you
select "does not equal" and *, the numbericals cells will be filtered.

Try this.

Regards

Jaleel
 
thank you, Jaleel
you really help me filter out numbers from English text, but I still finding
a way how to filter out the non-English text, any idea ? thanks again
 
kirkcwn said:
thank you, Jaleel
you really help me filter out numbers from English text, but I still finding
a way how to filter out the non-English text, any idea ? thanks again
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot use autofill after filtering 4
cannot use autofill after filtering 1
Seat arrangement of students in Exam 1
Excel 2003 Filtering Mistery 8
VBA set thick borders around non empty cells in range 0
Conditional Formatting Question 3
unique records by advanced filter 10
Creating A List of Items Between Two Numbers 2

Back
Top