I am importing a table into Access from and Excel spreadsheet being sent to me. I have a field that comes in as:
390 - 0013 etc.
(sometimes with spaces and sometimes without)
I need somehow to have these read as
I am not very good with calling code...so I'd like to use a query if possible.