Removing Letters within a Query

[Excel_77]

Hi All,

I have a query setup to pull a field called "Country" into my database that feeds from a linked spreadsheet.

Countries appear as follows

- UK(XX)
- France(XX)
- Belgium (XX)

How do I remove the (XX) from each country?

 

[Joe4]

If you are trying to remove it from the Access table, open up the table, highlight the column, and select Find/Replace from the Find ribbon on the Home menu.
Then, replace (XX) with nothing. Be sure to select the "Any Part of Field" from the Match selection.