I'm certain someone has a solution with far more finesse, but this appears to work, if I understand you correctly.
It seems although your delimiters are different, your data is consistant, at least the first 10 rows I checked.
Formulas assume:
- the Author ends at the first "
- the Title ends at the second "
- the Publication is the sentence following the Title
- the Remaining Info is all beyond the Publication
CAUTION: If your Title or Publication were to be 2 sentences (containing 2 periods) the formula would not return the desired results.
B2 =MID(A2,1,FIND("""",A2,1)-2)
C2 =MID(A2,FIND("""",A2,1)+1,FIND("""",A2,FIND("""",A2,1)+1)-LEN(B2)-3)
D2 =MID(A2,(LEN(B2)+LEN(C2)+5),FIND(".",A2,(LEN(B2)+LEN(C2)+5))- (LEN(B2)+LEN(C2)+5) +1)
E2 =MID(A2,LEN(B2)+LEN(C2)+LEN(D2)+6,LEN(A2))
copy formulas down
Bookmarks