• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Delete characters


New Member
If I have a cell like "AAI.O" and another cell "KK.D" and I wanted to remove the period and anything after it, result in another cell would be "AAII" and "KK" in adjacent cells, is there a function that would allow me to accomplish it?