Hi,
I'm trying to compare two columns but the problem is I have to do cleanup on one column. As seen below, I'm trying to clean up the below column where I only want to see the firm names and get rid of anything after that firm name.(\ CRD: 123242 \ IARD: 123242). The output should only have firm names. Can this be done using a replace formula or something else? Any help would be appreciated. Thank you in advance!
| Firm |
| MOTIF INVESTING, INC. \ CRD: 123242 \ IARD: 123242 |
| ARVEST INVESTMENTS, INC. \ CRD: 76839 \ IARD: 76839 |
| BAINCO INTERNATIONAL INVESTORS LLC \ CRD: 547383 \ IARD: 547383 |
