How do I split column at first space delimiter only?

For example John Smith Jr. to [John] [Smith Jr.] instead of [John] [Smith] [Jr.].
 

Question Info


Last updated June 13, 2019 Views 46,143 Applies to:
Answer
Answer

If you are only going to split into 2 cells then you could put this formula in the first cell to return the [John] part:

=LEFT(A1,FIND(" ",A1,1)-1)

and this formula in the next cell to return the right-hand part

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

133 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.