![]() Select the data range you want to filter, and click Data > Filter. Suppose you have a range of data as below screen shot shown, and you want to filter out the numbers which contain asterisk in the TelePhone column, please follow step by step:ġ. ![]() ![]() ![]() How to filter data by containing asterisk or other special characters in Excel?Īs we know, we use asterisk mask to stand any characters when you filter data, but how can you do if you want to filter data which contains asterisk mask? Now this article introduces the method about data filtering if containing asterisk or other special characters in Excelįilter data by asterisk or other symbol with Filterįilter data by special symbol with Super Filter
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |