why cannot filter records with ~ symbol in excel

Question

I have a list of record and I want to filter out those records that contain "~6". The problem is.... I can only filter if it is "~(space)6" but not "~6". When I try to filter "~6", I get the same list of result as when I filter the results which contain 6. I have been trying for whole day and has no idea what is wrong. Anyone can help? Thank a lot. Here is example data :

• ~6
• jhjh ~3
• dfdf~6
• dfdfd6dfdfd
• fgfg~6 fdfdd

Here is the result I want if I filter the records that contain ~6

• ~6
• dfdf~6
• fgfg~6 fdfdd

Answer 1

Try using a double tilde as the filter text, i.e., ~~6. (The tilde is the escape character for wildcard searches.)