I have a bunch of accounts i am extracting from my companies database, in the database we have the suite # keyed into the address field.
I am importing those addresses into a route planner but it will not accurately locate the accounts with the suite # in the fields.

For example:

Cell C6 reads (1200 SE 28th St, Ste 2)
How can i formulate something to remove (, Ste) and the following number throughout the entire workbook.

Thanks