How do you find and replace unwanted symbols in text cells?

  • Thread starter Thread starter cw2r44
  • Start date Start date
C

cw2r44

i AM IMPORTING EXCEL DATA TO ACCESS. ONE PARTICULAR SPREADSHEET HAS INVERTED
? SYMBOL (UNICODE HEX 00BF) IN A TEXT CELL. ACCESS WILL NOT IMPORT. I NEED
TO ELIMINATE THE SYMBOL AND REPLACE IT WITH A DASH. I'VE ATTEMPTED USING THE
FIND AND REPLACE FEATURE BUT HAVE NOT BEEN SUCCESSFUL. MANUAL EDIT IS NOT
POSSIBLE SINCE IT IS A VERY LARGE FILE. ANY SUGGESTIONS? THANKS.
 
Do the regular find/replace

on the find, put your cursor in the box and hold down the ALT key and punch
in the numpad (with numlock on) 1 6 8 and release ALT key, that will enter
the upside down question mark ¿ in the find field.

HTH
-Kevin
 
Back
Top