![]() |
#1
|
|||
|
|||
![]() 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
|
||||
|
||||
![]()
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
|
|||
|
|||
![]() Quote:
|
#4
|
|||
|
|||
![]()
IT works! Many thanks.
|
![]() |
Tags |
filter, wildcard |
|
![]() |
||||
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 |
![]() |
NobodysPerfect | Word | 10 | 03-19-2014 04:29 AM |
![]() |
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 |