@Left and @Right equivalent in Excel formula

Spreadsheet

=FIND("-",A2)

=LEFT(A2,B2-1)

=RIGHT(A2,LEN(A2)-B2)

Images/Screenshots:

Written by Frank Joseph Brefere III

Posted by fbrefere001 on Tuesday July 22, 2008