I need to split text by the first space. But since some rows don't either have multiple words with space between them or are empty, I get a #VALUE error for both the right and left column. How can I fix the errors? I use this for the text on the left of character:
=LEFT(A1,FIND(" ",A1)-1)
and this for the text on the right of character:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
and here's the sample file (just FYI):