This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
MOTIF INVESTING, INC. \ CRD: 123242 \ IARD: 123242
ARVEST INVESTMENTS, INC. \ CRD: 76839 \ IARD: 76839
BAINCO INTERNATIONAL INVESTORS LLC \ CRD: 547383 \ IARD: 547383