Extract string from variable length string

Hi, I have a macro that extracts the first & last name as one string from the data by using 2 x Find/Replace and then a Text To Columns. All Good. Data looks like what i have typed below. Spreadsheet attached.

Entry
1. John Smith (4)
2. Karren Phillips (10)
3. Jeff Grant (1)
4. Dale Jones (15)
5. Heidi Klugger (9)
6. Janette Morris (8)

I have seen in this forum that there is a much better way of being able to do it with a cell formula instead of macro. But I cant seem to make them work. (I am starting to understand how much I don't know and the people that contribute to this forum are indeed spectacular :-) )

From this data, all I am looking for is the name, which is fine to be in one cell. I want to strip off the numbers at the front and the parenthesis and numbers eg (4) at the back.

Thanks for your help.

Jeff

As every day passes I am just amazed at the strength of knowledge this forum has. I am truly grateful for its existence and the contributors. Thank you from Australia,