Removing digits from a column in Excel

Question

Hi, I have a column in Excel with names followed by numbers. I need to remove the numbers from all the names, how do I do that?

My column and rows B2:B6718 follow this pattern: Name (6digit_number)

I need to remove the (number) and the brackets surrounding the number.

Administration af fast ejendom på kontraktbasis (683210)
Administration af og bidrag til erhvervsfremme (841300)
Administration af sundhedsvæsen, undervisning, kultur og soc (841200)
Agenturhandel med blandet sortiment (461900)

Answer 1

how about

=MID( RIGHT(B3,8) ,2,6)

Answer 2

Using the Replace tool (ctrl+H), just replace (*) by nothing !

Answer 3

=MID(B3,1,LEN(B3)-9)