隨手記錄

【EXCEL】- 「~」特殊符號無法尋找及取代。Excel -  Symbol「~」Could not be use by Find & Replace

今天在使用EXCEL的VLOOKUP功能時，突然發現資料無法正常比對。在真因未明前，在數筆有問題的資料中，突然發現無法比的資料其字元都帶有「~」。心想在真因未明前，我先把「~」取代掉好了，其它的問題，日後有空再來慢慢找。

Today when I use VLOOKIP funtion in EXCEL and find out the data could not be show correctlly. In a few questionable materials, suddenly discovered that the characters that cannot be compared have "~". The root cause will be find out later, if we have free. We just to "find & replace" the symbol first.

此時使用「尋找及取代」，竟然也無法找到「~」這個符號！

We use "Find & Replace" and could not find the symbol  "~".

後來，終於找到解決辦法。方法即可「~~」，輸入兩次~。大家可以試看看

Finally we find out the solution, just type twice "~~" and then it could be find out. 

■ EXCEL 文書處理相關文章🔍