<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Hello, I am looking for a formula to convert a full name in the various formats seen below and convert them all to a consistent "last name only" cell in an adjacent column. I've been trying myself for a while, but am not making much progress. Does anyone know how to do this?
Thanks so much@
<colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>
</tbody>
Thanks so much@
Full name | Last Name | |
John Doe | Doe | |
Doe, John | Doe | |
John D. Doe | Doe | |
John Doe MD | Doe |
<colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>
</tbody>