Left Function to Stop at a Number

Hi. I want to know if there is a function that would stop at a number. For instance, "People's Place 15 Deer Yard", I would like a function that would stop at the 15 and only keep the "People's Place". I basically need an array in a search function. Nesting the sumproduct(--(isnumber(search())) does not work as it will only return the first value of the cell if there is a number. I would rather not nest 10 left functions detailing 1,2,3,4,5,6,7,8,9,0. I would much rather have a function that is much more contained. Thanks.

Thank you! I understand the first function but Richard can you explain your function to me? Thanks again. Pat