click below
click below
Normal Size Small Size show me how
LEFT MID LAST
| Question | Answer |
|---|---|
| MID | =MID(A1, FIND(" ", A1)+1), (FIND(" ", A1,FIND(" ",A1)+1) -FIND(" ", A1))) |
| LEFT | =LEFT(A1, FIND(" ", A1)) |
| RIGHT | =RIGHT (A1, LEN(A1)-FIND(" ", A1, FIND(" ", A1)+1)) |
| TO FIND FIRST SPACE POSITION FROM LEFT | =LEFT(FIND (" ", A1)) |
| FIND FIRST NAME FROM LEFT | =LEFT (A1, FIND (" ", A1, 1)) |
| FIND SECOND SPACE POSITION FROM LEFT | =FIND (" ", A1, FIND (" ", A1)+1) |
| FIND MIDDLE NAME | =MID(A1, FIND (" ", A1)+1),FIND(" ", A1, FIND(" ", A1)+1)- FIND (" ", A1)-1) |
| GET FULL NAME | =RIGHT(A1, LEN(A1)) |
| GET FIRST & MIDDLE NAMES | =LEFT(A1, FIND(" ", A1, FIND(" ", A1)+1)-1) |
| GET LAST NAME | =RIGHT (A1, LEN(A1)-FIND(" ", A1, FIND (" ", A1)+1)) |