How to Find and Replace Wildcard Characters in Excel

Finding as well as replacing required text as well as numbers is really tardily alongside the role of Wildcard Characters inwards Microsoft Excel. It mightiness endure unmarried occurrence or multiple occurrences – everything tin flame endure constitute as well as replaced easily using Wildcards. There volition endure a province of affairs that, rather than using the wildcard characters for searching text starting with, containing or ending with, you lot may desire to search for that item wildcard grapheme as well as supervene upon it alongside the text you lot want.

Find as well as supervene upon Wildcard characters inwards Excel

So, it agency that if nosotros desire to search for wildcard characters every bit normal text, thence at that spot volition endure a unlike way to create it.

Let us stimulate got the sample data,

The*windows club

The Windows Club

The windows*club

Here I desire to uncovering the ‘*’ symbol as well as supervene upon it. If you lot are non aware of how to create it, thence create non worry close it. In this article I volition allow you lot know how to create that.

First Attempt: Failed

Normally what nosotros create is simply press “CTRL + F”, come inwards ‘*’ inwards the ‘find’ plain as well as click on “Find All”. It volition exhibit all the entries inwards the search lawsuit as well as at that spot is no confusion inwards that. When nosotros search for ‘*’ it searches for everything as well as this is non what nosotros want.

Second Attempt: Failed

Now, allow us assay finding alongside the combination of ‘*’ as well as the text. Say, nosotros are searching for ‘windows*’ as well as what could you lot come across is, text starting alongside ‘windows’ inwards the search results. This is every bit good expected when finding using wildcard characters as well as pretty clear that this is every bit good non going to solve our problem.

Third Attempt: Success!

Problem inwards our outset as well as mo endeavour is that, Excel is treating the asterisk grapheme every bit wildcard grapheme as well as giving the lawsuit based on that. But, nosotros desire to search wildcard grapheme every bit the normal text.

So, nosotros postulate to brand Excel empathize that, nosotros desire to search asterisk every bit the normal text as well as non every bit a wildcard grapheme as well as it tin flame endure done. Yes, to brand that hap nosotros postulate to role the particular grapheme called Tilde ( ). We tin flame uncovering this particular grapheme left to the ‘1’ keypad on your keyboard. This is where I could come across on my keyboard as well as it may endure at unlike house on your keyboard based on the location where you lot are.

Now, when you lot come inwards ‘windows *’ inwards the uncovering plain as well as come across the results, thence you lot could come across the results containing the asterisk. This agency that nosotros could uncovering the asterisk every bit the normal text grapheme as well as nosotros are successful!

So, when nosotros desire to search whatsoever wildcard grapheme every bit the normal text, thence nosotros postulate to role Tilde ( ) special character along alongside the wildcard grapheme inwards the ‘find’ field.

This is the way to search wildcard characters inwards Excel every bit the normal text as well as this is ane of the tardily ways to create that.

If you lot stimulate got anything to add together or whatsoever other tardily ways, thence create portion alongside us through comments.

Source: https://www.thewindowsclub.com/

Share This :