Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Wildcard Search and Replace

In plain excel you can use wildcard for Search and Replace. Please include wildcard use in Power Query, and other Query editors.
Status: Needs Votes
Comments
admin171
New Member
I propose those wildcards: Sale !Sales for Sale but not Sales (! instead -) "Sale" for exact whole word Sale xxx* for starting with xxx *xxx for ending with xxx *xxx*yyy* for containing xxx and yyy (no matter in what order) x?y for xay, xby, x1y, x2y, .... but not xaby x#y for x1y, x2y, .... x&y for xay, xby, ....
fbcideas_migusr
New Member
Status changed to: Needs Votes