Filter Data using Wildcards
April 19, 2021
5 POWER BI TRICKS THAT WILL BLOW YOUR MIND
May 19, 2021
Find & Replace in Excel can be made very flexible using wildcard characters (*,? & ~).
When working with wildcard characters, positioning matters a lot, and for the characters to work certain settings need to be made in the find & replace dialog box.
Finding‘finance’
Shortcut to find: Ctrl + F
Say we want to find company names starting with finance. In the Find & Replace Dialog box, we enter ‘finance*’.
Replacing ‘finance’
Shortcut to Replace: Ctrl + H
Say we want the company names that end with ‘finance’ only to be replaced with ‘company’. We can do it in the following way.
Contributor: Sonia Keswani
I am a B.Com(Hons.) graduate from South City College (Morning) and have been working at Leveraged Growth as a Finance Intern for the past 1 month. I am pursuing CFA and aspire to be a Financial Analyst in the future.
