Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to filter for all part numbers beginning with 96745. The full numbers would be 9674528, 9674534,
etc. Following the dialogs under autofilter and custom, I select "begins with" and enter 96745. But after clicking ok the screen is blank, no records are found. What am I missing here? -- --------------------------------- --- -- - Posted with NewsLeecher v3.8 Beta 6 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Have you got spaces (or other non-visible characters) before your numbers?
If in doubt, try a formula such as =LEFT(A1,5) to check what your numbers do start with. -- David Biddulph "flumpf" wrote in message ... I am trying to filter for all part numbers beginning with 96745. The full numbers would be 9674528, 9674534, etc. Following the dialogs under autofilter and custom, I select "begins with" and enter 96745. But after clicking ok the screen is blank, no records are found. What am I missing here? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Autofilter won't work for me in this way if the part numbers are
genuine numerics - I presume this will be the case for you also. Assuming this is the case, and that conversion to Text of these part nos won't cause you an issue, then you can select the part nos column, go DataTextToColumns and when the dialog opens, click next, click Next again and select the Column Data Format to be Text. Now you can use "Begins With" in autofilter. Hope this helps! Richard On 22 Feb, 04:37, flumpf ) wrote: I am trying to filter for all part numbers beginning with 96745. The full numbers would be 9674528, 9674534, etc. Following the dialogs under autofilter and custom, I select "begins with" and enter 96745. But after clicking ok the screen is blank, no records are found. What am I missing here? -- --------------------------------- --- -- - Posted with NewsLeecher v3.8 Beta 6 Web @http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Or you could insert a helper column and convert the real numbers to text (that
looks like numbers). Either =a2&"" or =text(a2,"000000000") if you want to preserve leading 0's Then filter by that helper column. " wrote: I am trying to filter for all part numbers beginning with 96745. The full numbers would be 9674528, 9674534, etc. Following the dialogs under autofilter and custom, I select "begins with" and enter 96745. But after clicking ok the screen is blank, no records are found. What am I missing here? -- --------------------------------- --- -- - Posted with NewsLeecher v3.8 Beta 6 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom autofilter in excel | Excel Worksheet Functions | |||
Custom AutoFilter | Excel Worksheet Functions | |||
Can I use more than two conditions in custom autofilter? | Excel Worksheet Functions | |||
custom autofilter dropdown | Setting up and Configuration of Excel | |||
Custom Autofilter List | Excel Discussion (Misc queries) |