Hello! My goal is to truncate the contents of a cell to the 2nd period, coming from the end of the string (right to left). For example, if the string is "AB.CD.EF.GH.IJ.KL" I would like to trim it to "AB.CD.EF.GH" (removing the period after GH as well). Also, I need to perform this without using text-to-columns (the way I've been doing it) because I have hundreds of thousands of cells to truncate, and the number of periods in each cell varies greatly.
I've researched and haven't found anything that will trim the string from the right, to the 2nd period. Is there something simple that can do this?
Thanks!
Bookmarks