Importing nonprinting characters, then applying functions

[Access_Novice]

I have an Excel spreadsheet with data copied from the web. After pasting into Excel, there are some non-printing characters. To remove these non-printing characters and replace them with a blank in Excel, I can use this formula =SUBSTITUTE(A1,CHAR(160),"").

I don't want to keep entering this formula every time I do another copy and paste. I would like to just import the Excel spreadsheet (even though it contains non-printing characters) into a table, and have the table remove the non-printing characters.

Suppose the column that would receive the non-printing characters in the Access table is called 'ProjectName.' While in table design view, is there a way to enter a formula into the property sheet or somewhere that will automatically execute when the data is imported, so that the non-printing characters are removed?

[June7]

This cannot be programmed into table. Would have to run UPDATE sql action.

UPDATE tablename SET fieldname = Replace([fieldname],Chr(160),"");

[Access_Novice]

Ok. Thank you.