How to find sepecial characters in MS Excel

In MS-Excel find function is the most common function. But most people are don't know how to find special characters in MS Excel. Now it is very easy to just flow the following steps.

1st Step:

Open the Excel file select the "home" tab and select the "find & select" icon and select "Find". or you can use the "Ctrl + F" shortcut key on the keyboard.

image 01

image 02

image 03

2nd Step:

Now type Tilde (~) letter and your special character on your keyboard. ( ex: ~*, ~? etc ). If you want to find two special characters type Tilde (~) letter and special character and again type Tilde (~) letter and special character and press "Find Next" or "Find All" button. ( ex: ~*~*, ~?~? etc )

image 04

image 05