Hi, You can find a pattern in your text and select the part you want.
for example if your pattern is: select text until end of 'hospital' then do this:
=LEFT(A1;FIND("hospital";LOWER(A1))+8)
or maybe your pattern is: select text before first number then do this:
=TRIM(LEFT(A1;MIN(IFERROR(FIND("1";A1);1000);IFERROR(FIND("2";A1);1000);IFERROR(FIND("3";A1);1000);IFERROR(FIND("4";A1);1000);IFERROR(FIND("5";A1);1000);IFERROR(FIND("6";A1);1000);IFERROR(FIND("7";A1);1000);IFERROR(FIND("8";A1);1000);IFERROR(FIND("9";A1);1000);IFERROR(FIND("0";A1);1000))-1))
(1000 is a big number to help MIN function to find first happening of number characters and also select all text if there were no digits)
if you like to use VBA instead if Excel functions then other answers are complete and great.