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
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