Yet another excel question, something similar to left/right functions

I have a pretty massive spreadsheet and it has a listing of cost centers in it, by loan account number. About 4,200 of them, of which there are maybe 300 different centers. We are going through a big naming convention change, and I have identified which ones need to be renamed, and which ones need to have a new name altogether. Each cell with a cost center has some descriptions, like city name, area, etc. As well as a 10 digit number in parentheses at the end of it. I have a concatenate formula set up, but what I need to do is insert the new naming convention between the city/area name and the 10 digit number.

So for example, Birmingham would be:
Birmingham: XXXXX (1234567890) and I need to have it look like:
Birmingham: XXXXX - XYZ (1234567890).
I have all of the codes where the XYZ will go identified as well.

I have used a right formula to extract the 10 digit number, but I need a way to get just the characters in the cell prior to that number to show up. Only they are all city/area names so it isn't a standard number of characters so I can't use a simple left formula.

Any ideas?