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

[RajeshP]

Example:

1.ao.Univ.Prof. Dr. Peter Bettelheim 2.ao.Univ.Prof. Prim. DDr. Hermann Enzelsberger <tbody> </tbody> I need the below output from above name. Any one can help me. Answer should be:

<tbody>
</tbody>

1.ao.Univ.Prof. Dr.

<tbody>
</tbody>

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