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,

Hi,

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

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

hth,

Job

"Patience" <[email protected]> wrote in message
news:[email protected]...
>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,

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


"Patience" <[email protected]> wrote in message
news:[email protected]...
>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,

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

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

"Patience" <[email protected]> wrote in message
news:[email protected]...
>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,

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" wrote:

> Also If you find that you have spaces at the end of the data, incorporate
> Trim .
>
> =TRIM(LEFT(A1,FIND("(",A1,1)-1))
>
> "Patience" <[email protected]> wrote in message
> news:[email protected]...
> >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,
>
>
>

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))



"Patience" <[email protected]> wrote in message
news:[email protected]...
> 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" wrote:
>
>> Also If you find that you have spaces at the end of the data, incorporate
>> Trim .
>>
>> =TRIM(LEFT(A1,FIND("(",A1,1)-1))
>>
>> "Patience" <[email protected]> wrote in message
>> news:[email protected]...
>> >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,
>>
>>
>>

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

"Job" wrote:

> 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))
>
>
>
> "Patience" <[email protected]> wrote in message
> news:[email protected]...
> > 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" wrote:
> >
> >> Also If you find that you have spaces at the end of the data, incorporate
> >> Trim .
> >>
> >> =TRIM(LEFT(A1,FIND("(",A1,1)-1))
> >>
> >> "Patience" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >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,
> >>
> >>
> >>
>
>
>

Excellent thread.

It took the Patience of Job to get it done!

(sorry)

HA!
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Excellent thread.
>
> It took the Patience of Job to get it done!
>
> (sorry)