 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006I need a criteria expression to not include records that start wit
I have a list with some records that start with *. I would like to exclude these from the list with a query. I have tried Not Like '~*%' but it does not exclude the records. Does anyone have a suggestion for me. Hi Steve use an auxiliar column with this formula =if(lefet(a2,1)="*",mid(a2,2,255),a2) hth  Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > I have a list with some records that start with *. I would like to exclude > these from the list with a query. I have tried Not Like '~*%' but it does > not exclude the records. Does anyone have a suggestion for me. Thanks for your help but I am trying to accomplish this with query so I don't have to manipulate the table each time I re run the query. > I have a list with some records that start with *. I would like to exclude > these from the list with a query. I have tried Not Like '~*%' but it does > not exclude the records. Does anyone have a suggestion for me. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.