I have a cell that reads "Sidney Crosby, C" and I want it to create a formula to translate that to "Sidney Crosby" How would I do that?
I used the formula below which I found online to do something similar but it's bringing that comma with it.
=LEFT(C77,(FIND("|",SUBSTITUTE(C77," ","|",2)))-1)
Bookmarks