I have the following Table:

Book1 | ||||||
---|---|---|---|---|---|---|

A | B | C | D | |||

2 | Data | Desired | ||||

3 | NorthLosAngelesBranch | NorthLosAngeles | ||||

4 | TorontoBranch | Toronto | ||||

5 | SanAntoniaBranch | SanAntonio | ||||

6 | DesMoinesBranch | DesMoines | ||||

Sheet1 |

Can someone please show me a formula that will extract all the data before branch. The data is in the first column. I am looking for a formula to place in the desired and drag it down.

Thanks so much