| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter
how to filter a column that some cells are numbers, some cells are English
word, some cells content non-English word. thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter
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 "kirkcwn" wrote: how to filter a column that some cells are numbers, some cells are English word, some cells content non-English word. thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter
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 "Jaleel" wrote: 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 "kirkcwn" wrote: how to filter a column that some cells are numbers, some cells are English word, some cells content non-English word. thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter
Hi,
Sorry, no idea. Let the experts talk! Regards, Jaleel "kirkcwn" wrote: 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 "Jaleel" wrote: 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 "kirkcwn" wrote: how to filter a column that some cells are numbers, some cells are English word, some cells content non-English word. thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter
"kirkcwn" wrote: 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 "Jaleel" wrote: 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 "kirkcwn" wrote: how to filter a column that some cells are numbers, some cells are English word, some cells content non-English word. thank you |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter
"Jaleel" wrote: Hi, Sorry, no idea. Let the experts talk! Regards, Jaleel "kirkcwn" wrote: 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 "Jaleel" wrote: 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 "kirkcwn" wrote: how to filter a column that some cells are numbers, some cells are English word, some cells content non-English word. thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Linear Mode
