Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Made this change: change your function separator from a comma to a semi-colon (Tools > Options... > LibreOffice Calc > Formula).

This =LEFT(A2;SEARCH("[ ][A-Z]";A2)) returned #VALUE!

I put this =TRIM(LEFT(A2;SEARCH("[ ][&][ ]";A2))) in B2 and it returned #VALUE!

Since the above didn't work to return the correct value in B2, I did not try this =TRIM(RIGHT(A2;(LEN(A2)-LEN(B2)))) or this =RIGHT(C2;LEN(C2)-2) # to give "RALPH H JR" in D2

Nonetheless, I appreciate the effort to help with this.