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

Word macro that can call cells out of Excel for a find and replace 0
Find and Replace unwanted symbol 6
Is there an advanced "search and replace" for Microsoft Publisherapplication/add in? 0
Find & Replace in Excel 2007 3
Symbol "font" - not Unicode compliant, how to Search/Replace? 2
How Do I Replace Paragraphs With New Paragraphs In Excel? 8
how do I use macro to find and replace unicode characters 6
Can I replace a ' at the beginning of a text cell using Replace 4

Top