Hi,

Assuming your data is in cell "A1" try this;

=LEFT(A1,FIND("(",A1,1)-1)

hth,

Job

"Patience" wrote in message
...
I have a large spreadsheet of text -- survey responses. At the end of each
response, there is a number in parens indicating the respondant number. It
looks like this:

I liked this course. (1)
I think we could have benefited from hands on training. (12)
I would recommend this course to others. (8)

I need to remove the parens and everything in between. Can someone help me
out with code to do this; I don't want to have to delete each by hand!!

Thanks,