View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patience Patience is offline
external usenet poster
 
Posts: 3
Default need to remove last few characters from data in field

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,