I goofed! When I extracted First Names & Last Names from a string, it picked up the middle initial. How can I delete the last letter from a string ONLY if it's in caps? Here's an example of my data:
<colgroup><col></colgroup><tbody>
</tbody>I could just run the formula again that split the First and last names but this seemed like a challenge I might need to know the answer to at some point. Thanks all! Enjoy the Board....
Anna |
Anna |
AnnaM |
AnneB |
AnneE |
AnneG |
Annette |
AntonioL |
April |
AprilB |
AprilD |
AprilD |
AprilM |
<colgroup><col></colgroup><tbody>
</tbody>