Spliting a cell

[Jim]

Hi all,

I have a full name in cell A1. I want to put the first name in cell A2 and
the Last name in cell A3. The names are present traditionally: Jim Smith.
Can you help me out?

Thanks

 

[Jacob Skaria]

You can try menu Data>Text to Columns>Delimiter and select space to split
this to two columns. If you are looking for formulas try the below

In B1
=TRIM(LEFT(A1,FIND(" ",A1)-1))

In C1
=TRIM(MID(A1,FIND(" ",A1)+1,LEN(A1)))

If this post helps click Yes

 

[Jacob Skaria]

With error handling
In B1
=TRIM(LEFT(A1,FIND(" ",A1 & " ")-1))

In C1
=TRIM(MID(A1,FIND(" ",A1 & " ")+1,LEN(A1)))

If this post helps click Yes