255
edits
Excel Data Quality Toolkit: Difference between revisions
→Incorrect Character Encodings
| Line 132: | Line 132: | ||
'''Solution:''' | '''Solution:''' | ||
# In the Editing section of the Home menu, click Find & Select, then Replace. | |||
# Use [https://www.i18nqa.com/debug/utf8-debug.html this resource] to search for mis-rendered special characters in your dataset. For example, you could enter "Ã" into the "Find what:" field to find all mis-rendered symbols in the rightmost table, click Find Next, and then replace it with the correct value in the "Expected" column of this table. | |||
# To replace all instances of a particularly common mis-rendered symbol (e.g., "é", which is mis-rendered as "é"), enter the incorrect value (é, in this example) in the "Find what:" field and the correct value (é, in this example) in the "Replace with:" field. Then click Replace All. | |||
=== Incorrect Line Endings === | === Incorrect Line Endings === | ||