Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-10-2015, 03:05 AM
albza albza is offline filtering row with a wildcard in excel Windows 8 filtering row with a wildcard in excel Office 2007
Novice
filtering row with a wildcard in excel
 
Join Date: Feb 2015
Posts: 3
albza is on a distinguished road
Question filtering row with a wildcard in excel


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
Reply With Quote
  #2  
Old 03-10-2015, 07:19 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline filtering row with a wildcard in excel Windows 7 64bit filtering row with a wildcard in excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

That depends on the way you are trying to filter.
Anyway, to transform a "wild-card asterisk " to a normal character use ~* ( asterisk preceded by a tilde)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 03-10-2015, 07:22 AM
gebobs gebobs is offline filtering row with a wildcard in excel Windows 7 64bit filtering row with a wildcard in excel 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
  #4  
Old 03-14-2015, 12:00 PM
albza albza is offline filtering row with a wildcard in excel Windows 8 filtering row with a wildcard in excel Office 2007
Novice
filtering row with a wildcard in excel
 
Join Date: Feb 2015
Posts: 3
albza is on a distinguished road
Talking Ok

IT works! Many thanks.
Reply With Quote
Reply

Tags
filter, wildcard



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
filtering row with a wildcard in excel Tricky wildcard search NobodysPerfect Word 10 03-19-2014 04:29 AM
filtering row with a wildcard in excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft