Left and Right functions
Posted by Carl on January 31, 2001 8:59 PM
Is there a way to pull everything from the left of a delimeter or certain charachtor that is specified.
Same question to the right of charachtor.
Posted by Aladin Akyurek on February 01, 2001 1:06 AM
Enter in A1
left.right
in B1
=LEFT(A1,FIND(".",A1,1)-1)
in C1
=RIGHT(A1,LEN(A1)-FIND(".",A1,1))
Aladin
