Extracting Text from the right
- From: "L Ellis" <LEllis@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Jul 2005 08:51:06 -0700
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
.
- Follow-Ups:
- Re: Extracting Text from the right
- From: Harlan Grove
- Re: Extracting Text from the right
- From: Domenic
- RE: Extracting Text from the right
- From: Ron Coderre
- RE: Extracting Text from the right
- From: bj
- RE: Extracting Text from the right
- From: bj
- Re: Extracting Text from the right
- Prev by Date: determine if a cell changed value
- Next by Date: Re: What happened to "Tab Color" for worksheets?
- Previous by thread: determine if a cell changed value
- Next by thread: RE: Extracting Text from the right
- Index(es):