MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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