AtLeft and AtRight in Excel

Microsoft Excel

If value is XX-XXX

=LEFT(A2, SEARCH("-", A2)-1)
=RIGHTT(A2, SEARCH("-", A2)-1)

Written by fbrefere001

Posted by fbrefere001 on Friday February 7, 2025