Dear all

I have export some data from Access xp
when i am looking the data to excel there is a single quota and so when i am
trying to import the data to access again then the search option in the
access do not work properly.
The case is if it is possible to create a formula that i can run in excel in
order to subtrack the quota (') from the cell.


I used TRIM formula and a subtrack the spaces from the front and the back of
the data

Any good ideas of how can i delete the quota?

Thanks in advance
Manos