Since there can be more than one "." in the text string, try this (for text
in Cell A1):

For the chars to the right of the last ".":
=RIGHT(A1,MATCH(".",MID(A1,LEN(A1)+1-ROW(INDIRECT("1:"&(LEN(A1)))),1),0)-1)

For the chars to the left of the last ".":
=LEFT(A1,LEN(A1)-MATCH(".",MID(A1,LEN(A1)-ROW(INDIRECT("1:"&(LEN(A1)))),1),0)-1)

NOTE: Commit both of those array formulas by pressing [Ctrl]+[Shift]+[Enter]

(The formulas reverse the text and search for the "." from the left.)

Does that help?
--
Regards,
Ron


"L Ellis" wrote:

Hi -

Am looking for some help writing an equation to extract from the right of a
string.

Here is a sample of data:

esolent.com
1glend.dialup10.famvid.com
1n7.8774.1n-129.nethost4.biz
1n7-93.servernode.net
2.inexo.com
2.wencor.com.uk
20.tieless.com
9-inet3.static.ac1-lax.aubeta.net
bsdwebsolutions.com
cache.es

What I want to do is write two equations:

1) To extract to the right of the last "."
2) To extract to the left of the last "."

The standard excel formulas count from the left to the right and not the
right to the left, thus my problem.

Thanks!
L