What if you want to do it the other way? I have a list of data that I need to get rid of and appears as 3 characters after a hyphen e.g. -xxx. There are 3 or 4 entries of the same thing the only difference being the suffixes. I need to remove all the suffixes but I need to check all the data the rows contain first as i need to do some merging before deleting the extra entries. Any ideas?!