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

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.
 
K

Kevin Barrios

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace unwanted symbol 6
Can I replace a ' at the beginning of a text cell using Replace 4
find and replace symbols 8
How Do I Replace Paragraphs With New Paragraphs In Excel? 8
Using "Find and Replace" for Symbols 4
How do I find and replace the " 8
How do you Find and Replace the word "and" but not the and in "han 4
Find and replace with bold in cells 3

Top