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.