Extracting Fields from String

[ManUBlueJay]

I am working on a very large genealogy project. I need to be able to extract date, first name of person and parents name. the data will appear like this (Very consistent spaces) in A2:
January 2 Joey Joseph Schmoe (Joe & Josephine).
I would like 3 separate cells. B2:"January 2", C2:"Joey", D2: "Schmoe (Joe & Josephine)"

Thanks

 

[admiral100]

Hi,

Try this : depends of course the consistency of spaces in the sentence...

B2 =LEFT(SUBSTITUTE(A1," ","*",2),FIND("*",SUBSTITUTE(A1," ","*",2))-1)
C2 =MID(A1,FIND("*",SUBSTITUTE(A1," ","*",{2,3}))+1,(FIND("*",SUBSTITUTE(A1," ","*",3))-FIND("*",SUBSTITUTE(A1," ","*",2))))
D2 =MID(A1,FIND("*",SUBSTITUTE(A1," ","*",4))+1,60)

	A	B	C	D
1	January 2 Joey Joseph Schmoe (Joe & Josephine)	Date	Name	Details
2		January 2	Joey	Schmoe (Joe & Josephine)

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[ManUBlueJay]

Hi,

Try this : depends of course the consistency of spaces in the sentence...

B2 =LEFT(SUBSTITUTE(A1," ","*",2),FIND("*",SUBSTITUTE(A1," ","*",2))-1)
C2 =MID(A1,FIND("*",SUBSTITUTE(A1," ","*",{2,3}))+1,(FIND("*",SUBSTITUTE(A1," ","*",3))-FIND("*",SUBSTITUTE(A1," ","*",2))))
D2 =MID(A1,FIND("*",SUBSTITUTE(A1," ","*",4))+1,60)

	A	B	C	D
1	January 2 Joey Joseph Schmoe (Joe & Josephine)	Date	Name	Details
2		January 2	Joey	Schmoe (Joe & Josephine)

<tbody>
</tbody>

Works Perfect
|Thank you