Hi All:
I have the following Table:
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
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