Removing last few letters of string

[Gary]

Hi,

I have a values in a list of cells (in cells A1:A100),
which each contain a school's name followed by the number
of pupils in that school in brackets

i.e.
School 1 (546)
School 2 (604)
School 3 (292)
etc.

I want a formula in cells B1 through B100, say that looks
up the school name contained in cells A1 to A100, and
returns other values.

My question therefore is how do I get ONLY the name of the
school (and not the school plus the pupil numbers) into
the lookup formula??? i.e. how do I remove the last 6
characters (i.e. space, bracket, number, number, number,
bracket)???

I know I have to use some combination of left, mid and
right here, but I am stumped,

Many Thanks

Gary.

 

[Aladin Akyurek]

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

 

[Gary]

Hi,

It's OK,. I got it - I used:

=LEFT(B49,FIND("(",B49)-2)

Thanks anyway,

Gary.

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[Paulw2k]

The simplest formula would be

=LEFT(A1,LEN(A1)-6) (in B1, then copy down)

though this assumes pupil numbers are between 100-999 in all cases.