The data is as John Conroy (IRE) and James Edgar (USA) all down one
column - and I'd like it to look like John Conroy and James Edgar, the same
as it began but without the brackets and suffix. There are no numbers or
special characters whatsoever involved in this column, just text.



"JMay" wrote in message news:gqFsd.425$ln.325@lakeread06...
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