• 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

    Hui...

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

Delete characters

rickbw

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?
 
69103

Above is visual of what I am attempting to accomplish
 

Attachments

  • 1592391332065.png
    1592391332065.png
    11.7 KB · Views: 4
Back
Top