How to read Read character from Right to left and return the characters

[RajeshP]

Example:
[TABLE="width: 295"]
<tbody>[TR]
[TD="width: 295"]1.ao.Univ.Prof. Dr. Peter Bettelheim
[TABLE="width: 221"]
<tbody>[TR]
[TD="width: 295"]2.ao.Univ.Prof. Prim. DDr. Hermann Enzelsberger[/TD]
[/TR]
</tbody>[/TABLE]


I need the below output from above name. Any one can help me.

Answer should be:
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 295"]
<tbody>[TR]
[TD="width: 295"]1.ao.Univ.Prof. Dr.[/TD]
[/TR]
</tbody>[/TABLE]
2.ao.Univ.Prof. Prim. DDr.

Key workd is Dot. I need the characher before dot(.)

 

[Tetra201]

Maybe

=LEFT(A1,FIND(".@",SUBSTITUTE(A1,".",".@",LEN(A1)-LEN(SUBSTITUTE(A1,".","")))))

 

[RajeshP]

Hi Tera201,

Great!.. Its working fine.

Also, I want to split First name and last in the same Name. Could you please help me to get the formula for the same.

Example: 1.ao.Univ.Prof. Dr. Peter Bettelheim
2. apl.Prof. Dr. Siegfried Georg Priglinger

Output should be:
1. First Name last name
Peter Bettelheim
2. First Name last name
Siegfried Georg Priglinger

Kindly do the needful