{"id":3523,"date":"2018-11-30T16:01:44","date_gmt":"2018-11-30T16:01:44","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3523"},"modified":"2024-03-28T10:34:34","modified_gmt":"2024-03-28T10:34:34","slug":"how-to-replace-wildcard-characters","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/how-to-replace-wildcard-characters\/","title":{"rendered":"Replace Wildcard Characters in Excel"},"content":{"rendered":"\n
Wildcard characters such as a ? (question mark) and * (asterisk) are used to represent a single character or any number of characters.<\/p>\n\n\n\n
Example:<\/strong><\/p>\n\n\n\n But, what if you want to replace a wildcard character inside a string?<\/p>\n\n\n\n In this article, I\u2019ll show you how you can do it.<\/p>\n\n\n\n? (question mark)<\/td> Finds a single character.
For example, d??m finds \u201cdoom\u201d and \u201cdorm\u201d<\/td><\/tr>* (asterisk)<\/td> Finds a number of characters.
For example, c*d finds connected and caged<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nReplacing a wildcard character<\/h2>\n\n\n\n
\n