Remove Characters from String in Excel

[p4nny]

Hi

I would like to remove the remove characters after the final "." so the below would read 15.3.9.6

The only trouble I'm having is the final "." is in varied position.

Much appreciated

[TABLE="width: 125"]
<tbody>[TR]
[TD]15.3.9.6.9[/TD]
[/TR]
[TR]
[TD]15.3.9.6.10[/TD]
[/TR]
[TR]
[TD]15.3.9.6.11[/TD]
[/TR]
[TR]
[TD]15.3.9.6.12[/TD]
[/TR]
[TR]
[TD]15.3.9.6.13[/TD]
[/TR]
</tbody>[/TABLE]

thank you

 

[wideboydixon]

Book1
	A	B
1	15.3.9.6.9	15.3.9.6
2	15.3.9.6.10	15.3.9.6
3	15.3.9.6.11	15.3.9.6
4	15.3.9.6.12	15.3.9.6
5	15.3.9.6.13	15.3.9.6
Sheet1

Cell Formulas
Range	Formula
B1	=IFERROR(LEFT($A1,FIND(CHAR(1),SUBSTITUTE($A1,".",CHAR(1),LEN($A1)-LEN(SUBSTITUTE($A1,".",""))))-1),$A1)

WBD

 

[Haluk]

If the number of characters before the last "." is the same as in your sample data, you can use:

=LEFT(A1,8)

Otherwise; you may use the below formula, which extracts the string before the 3rd occurence of "."

=LEFT(A1,FIND(".",A1,FIND(".",A1)+3)+1)