extract characters on a string

[kbgato]

I have strings like the following

06.-.Jekyll.And.Hyde.And.Ted.And.Alice.m0008
06.-.Jekyll.And.Hyde.And.Ted.And.Alice.p09

I would like to extraxt the las characters from the last period (.),
this is; m0008 on the first and p09 on the second.

Can you give me some ideas?

Thanks in advance

 

[Scott Huish]

=TRIM(RIGHT(SUBSTITUTE(A1,".",REPT(" ",LEN(A1))),LEN(A1)))

 

[mikerickson]

Are the number of periods always the same? If so,

1)use SUBSTITUTE to change the nth period to a CHAR(5)
2)use FIND to find the location of CHAR(5) in the changed string
3)use MID to chop off everything after that point.

If the number of periods varies.

=Len(string)-Len(SUBSTITUTE(string,"",".") will give you the number of periods. From which you can use steps 1-3

 

[kbgato]

Thanks Hotpeper it was grate.
Thanks mikerickson, I made a little change on your answer and it works fine.