Nice improvement to my formula, Harlan....Thanks.

----
Regards,
Ron


"Harlan Grove" wrote:

L Ellis wrote...
Am looking for some help writing an equation to extract from the right of a
string.
....
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 "."
....

Others have already responded with the standard approaches. I'd modify
the approach Ron Coderre took. Define a name like seq referring to the
formula

=ROW(INDIRECT("1:1024"))

Then use regular (nonarray) formulas like

1. =MID(A1,LOOKUP(2,1/(MID(A1,seq,1)="."),seq)+1,1024)

2. =LEFT(A1,LOOKUP(2,1/(MID(A1,seq,1)="."),seq)-1)