need to remove last few characters from data in field

[Guest]

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,

 

[Job]

Hi,

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

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

hth,

Job

 

[Job]

Also If you find that you have spaces at the end of the data, incorporate
Trim .

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

 

[Ross Culver]

If you're just wanting to remove the end try this:

left(range("").value, len(range("").value) - 4)
or
=left(C4, len(C4) - 4)

where C4 is the cell reference.

Ross

 

[Guest]

One more question.... where/how do I use this formula? I'm not sure where to
paste it to make it work.

Thanks Patience

 

[Job]

If your data is in column A and starts in cell A1 you can put the formula in
cell B1 and B1 will now be the correct sentence. You then copy the formula
down the length of your data and it should look correct.

Example
ColumnA ColumnB
I liked this course. (1) =TRIM(LEFT(A1,FIND("(",A1,1)-1))

 

[Guest]

Wonderful -- it worked (but then again, you knew it would!) Thank you, thank
you!

 

[Dave Peterson]

Excellent thread.

It took the Patience of Job to get it done!

(sorry)

 

[Job]

HA!