Calculated column Split in SharePoint list

For Example
Create Calculated column called "EMP-01" and type in this formula

=LEFT([ID],INT(FIND("-",[ID])-1))
Result :
EMP
Create Calculated column called "Employee ID" and type in this formula


=RIGHT([ID],LEN([ID])-INT(FIND("@",[ID])))

Result:

01