 You need to watch this video if you're trying to use find and replace with wild cards in Excel. In our scenario we have asterisks and question marks but we want to replace them with a space. We'll use Ctrl F to open up find and replace, we'll go to replace and you can see I've already entered the question mark that I want to find and a blank space that I want to replace it with. You can see Excel thinks it's done what you want it to where in fact it's just removed all of our values but what we need to do is include an additional symbol which is known as a tool there. So I'll just click in front of the question mark, I'll hold the shift button and then push the hashtag button as well and you can see we have this new symbol. Just check I still have a space in there that I want to replace the question mark with, replace all and you can see it's now replaced our question marks, we'll then replace the question mark with an asterisks and you can see it's now done that for us as well. Please don't forget to like if you enjoyed this video.