left function without set number of characters

Hello! Hoping someone can help me with a quick question.

I have a list that looks like below. I want to extract just the beginning portion (i.e. North, South, Western Hills, etc.). I tried the formula indicated below, but would like to trim it down further if possible.

North 7:20 IN #7 - BUS
South 8:45 IN BUS #3
Western Hills 5:00 HM BUS #2
Belvedere 3:55 HM BUS #3

=LEFT(H7,LEN(H7)-FIND(" ",H7))

That formula is returning Belvedere 3:55. Sometimes it includes more characters from the original. Any way to pull just the left most words?

Any help is appreciated!!
Thank you,
Courtney

If your data starts in A1, enter this into B1 and copy down: =TRIM(LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1))

If this helps you, please mark as solved.

Pete

Thanks!!! :D

Glad to help.

Pete