Truncate Contents of a Cell from the Right

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!

Is it always 2 characters between the period? It would help if you gave a few more examples of your starting strings.

Pete

Apologies, it's actually a long file path, and i need to remove the file name at the end. So actually, I need to trim to the first "/". So for instance:

file://entshare/Shared/Everyone/08 EEMP GRADS/AA QA Automation Results/Encompass Automation/JanKRI.xls

And i want to remove the /JanKRI.xls

But some paths are much shorter and much longer. Sorry for the confusion.

Using text to columns becomes cumbersome because each path has varying amounts of "/"

How about

Formula:

Please Login or Register  to view this content.

Thanks for the reply, but that is returning #VALUE!

This is what I get

Excel 2013 32 bit

	A
1	file://entshare/Shared/Everyone/08 EEMP GRADS/AA QA Automation Results/Encompass Automation/JanKRI.xls
2
3	file://entshare/Shared/Everyone/08 EEMP GRADS/AA QA Automation Results/Encompass Automation

Sheet: Quote

Excel 2013 32 bit

	A
3	=LEFT(A1,FIND("~|",SUBSTITUTE(A1,"/","~|",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))-1)

Sheet: Quote

Yes, that looks like what I need. I pasted directly into my document, but I'm still getting #VALUE! Could it perhaps be formatting issue? Any other ideas? Thanks again..

Actually I got it to work. THanks a lot!

Glad you sorted it & thanks for the feedback