I didnt know about cntl+H, thats great info to have but unfortunately I
need to keep the dates for future reference. Thanks for the effort!

"shail" wrote:

Else, you can use Ctrl + H (to find and replace)

1. Select the rows over where you want to remove FEB 3.
2. Press Ctrl + H.
3. On the first box enter (FEB 3) and on the second box don't enter
anything. And press Replace All button. So you will get rid of (FEB
3).

Hope this helps

Thanks,

Shail

On Feb 5, 9:28 pm, mmcap wrote:
I have to copy data from an excel sheet on a website to my excel sheet. The
company that I get the data from doesn't separate the DATE from the name of
the data e.g. [ICSC-UBS (FEB 3)] is in one cell. When I paste the data from
the website my sheet still has info that I pasted from the previous month. I
need to be able to identify any duplicate entries but the date at the end
keeps it from being an exact duplicate because the date has changed. The
formula that I'm using right now is
=IF(COUNTIF($A$2:$A$150,A115)1,"Duplicate","") this will give me the word
Duplicate in the rows where there is an exact match but I still need to watch
carefully to be able to keep the old data weeded out. I've tried variations
with RIGHT, LEFT , and , LEN but haven't had any success. I need to be
able to ignore the last 6 char "(FEB 3)" in the cell that contains the
[ICSC-UBS (FEB 3)] in order for there to be an exact match. Does anybody
have any ideas?