Excel VBA - 替换非英文字符

im currently mapping some addresses from one excel sheet into another, this requires me to do specific things such as changing the column orders, deleting duplicate rows, and cutting the page into 100-row sheets...i also need to replace non-standard characters with their closest English equivalent.im currently mapping some addresses from one ex