filtering row with a wildcard in excel

gebobs · #3 03-10-2015, 07:22 AM

Quote:

Originally Posted by albza

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 ~*.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change characters outside a wildcard while keeping wildcard results	nymusicman	Word VBA	2	04-10-2014 08:17 AM
Tricky wildcard search	NobodysPerfect	Word	10	03-19-2014 04:29 AM
Wildcard for selective deleting	binar	Word	1	01-10-2013 04:37 AM
Wildcard search help.	Kempston	Word	0	11-13-2009 03:58 AM
Filtering out CC's	arzsupra	Outlook	0	03-11-2008 05:55 PM