I need to remove certain info from a cell while keeping the rest of the info

Hello and thank you in advance to everyone that assisted.

I was wondering if there is a way to get rid of certain information in a cell. Example....CITY FURNITURE (1492) how do I get rid of the (1492) and just leave the City Furniture? In this example... KINGS CREDIT SERVICE *G (5881) - I want to get rid of *G (5881). I have a list of 12,000 creditors and want to know if there is a program to accomplish this? Then I can get to doing what i really need to do with the list.

I was also wondering if anyone was interested in possibly helping me create(or you create and I pay?) a basic user interface portal.

Thanks again to any and everyone that assisted!

I did attached the sheet I am trying to do this with showing the examples.

Excel is Cool

HOw do I get rid of the "G*" after the creditor name?

Try

=IFERROR(LEFT((LEFT(B2,FIND("(",B2)-1)),FIND("*",B2)-1),LEFT(B2,FIND("(",B2)-1))