Split the Data into Multiple parts

Split the data into multiple parts
(i)First Part (ii) Second Part (iii) Third Part

Funtions Used:

Left Function
Right Function
MID Function
Find Function

First Part:

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

Middle Part:

=MID(A3, FIND(" ", A3, 1)+1,FIND(" ",A3,FIND(" ",A3,1)+1)- FIND(" ", A3, 1)-1)

Last Part:

=RIGHT(A3,LEN(A3)-FIND(" ",A3,FIND(" ",A3,1)+1))

Download The Workbook