Question

Q: How do I split column at first space delimiter only?

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

Answer

A:

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))

Did this solve your problem?

Sorry this didn't help.

106 people were helped by this reply



 
Question Info

Views: 37,888 Last updated: May 26, 2018 Applies to: