I don't know my suffixes from my prefixes . . .
Use the Open paren as the Delimiter, instead, if you are removing a suffix
and there are no spaces between the number and the (IRE).
If there is a space, use that as the Delimiter.
tj
"tjtjjtjt" wrote:
Check out Data | Text to Columns.
Set the Delimiter to the close paren, ), using the other box.
tj
"Dark Horse" wrote:
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
|