 | 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.
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
