Data Prep. (Removing words that come after \)

[badleopard]

Hello there guys,

I am in the process of cleaning some data and I'd like to know how I could get rid of any word and/or letter(s) that come after \ in the player column including the \ symbol only to remain with the name only.

[diver999]

If the data is in cell A1 for instance, use =LEFT(A1,FIND("\",A1)-1)

This will return all characters to the left of the \. If there's a chance that the cell doesn't contain a \, then use =IFERROR(LEFT(A1,FIND("/",A1)-1),A1) which will return the whole text when there is no \.