Showing a couple examples will insure a more specific suggestion.
Is the data 1234567(IRE) or ABCDEFG(IRE) for example?
What you want it to look like afterwards? $12,345.67 and/or Abcdefg??


"Dark Horse" wrote in message
...
I download a list of data each day, and a lot of it comes with a suffix in
brackets showing the country of origin of the piece of data - (IRE) as an
example.
Because of the suffix, my data doesn't recognise the two things as the
same
so I end up having to remove all the suffixes by hand.
Is there any way of accomplishing this in a neater and quicker way?
Thanks in advance
Cheers
Dave