|
|
#1
03-10-2015, 03:05 AM
|
|||
|
|||
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 
|
|
#2
03-10-2015, 07:19 AM
|
||||
|
||||
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
|
|
#3
03-10-2015, 07:22 AM
|
|||
|
|||
|
Quote:
|
|
| 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 |
 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 |
Windows 8 
Office 2007
Ok
Linear Mode
