you need ot first findout how many "." there are
=len(A1)-len(substitute(A1,".",""))
you then need to find where the last one is
=find(".",A!,len(A1)-len(substitute(A1,".","")))

to extract what is to the right of the last .
=right(A1,len(A1)-find(".",A1,len(A1)-len(substitute(A1,".",""))))

and to the left
=left(A1,find(".",A1,len(A1)-len(substitute(A1,".","")))-1)

"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