Replace

[aparna0208]

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

[BrandonB · Accepted solution]

Can you use the Text to Columns tool using \ as your delimiter to split your column into two new columns on the backslash? 

[BrandonB · Accepted solution]

 

[aparna0208]

Awesome:) It worked. Thank you so much for your inputs on this @BrandonB