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

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.

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

This worked for me...

=SUBSTITUTE(A1, "¿", "-")
--
HTH...

Jim Thomlinson


"cw2r44" wrote:

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.

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

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



"cw2r44" wrote:

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.