Thread: [Solved] filtering row with a wildcard in excel
View Single Post
 
Old 03-10-2015, 07:22 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Quote:
Originally Posted by albza View Post
in a firm they use SAP. They decided to assign the character * before the name of every ended product.
Then they export all the datas in ms excel.
It's not possibible to filter only theproductswith * because excel consider it as a wildcard.
Which should be the solution? It's not possibible for them change character.
thanks
Delete the asterisks in the export. This can be done by doing a find/replace of ~*.
Reply With Quote