This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The square is what's displayed when you have a character that isn't in the current code page. The character in the DB is probably an Em Dash U#8212 or an En Dash U#8211 neither of which are standard ascii characters. If you use CharToInt on that character you can see exactly what the code is for it. Once you have that, try using Replace([Fieldname],CharFromInt(CharCode),"-") in a formula tool.