MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Advanced filter !!!

Posted by Sasa on February 05, 2002 2:52 AM

Dear all,
I would like to filer data in column. What should I put in criteria if I want to show only datas which starts with number (ex. 1234, 123jhkjh, 24jhkjh, 87687)
Thanks in advance for any halp.

Posted by Aladin Akyurek on February 05, 2002 6:28 AM

See: 20258.html.

Posted by Excel Prince on February 05, 2002 8:04 AM

Try this: keep data as text and check criteria >="0" and <":"