Need the excel formula

In older computer systerns, multiple values were often stored in a single cell to save space. This practice is sometimes still followed today. For example, an employee identification number may tell you the employee number, plant number and business function. That is, 143-01-Acc could identify employee 143, from plant 01, who works in accounting Fot this step, look in the Separated Data sheet that contains 597 rows of employee data. There you will find three columns. EmployeeCode, FirsiName and LasiNarne The EmployoeCode is the combination of four different fietds. Location, EmplD, PlantiD and PayPoniod Each of these fiolds is defined as follows: - Location. The location code shows the location where the employee works. The company operates in eight different countries Aggentina (ARG), Australia (AUS), Canada (CAN), England (ENG), Gormany (GER), Japan (JAP), Moxico (MEX) and the United States of America (USA) The country codes are always three digits and are the first three digits in the EmployeeCode, reading from left to night. - EmplD: The company assigns a random employee identification number from 1,000 10 1,597. Rrading the EmployeeCode from loft to right, the EmpID is the In older computer systerns, multiple values were often stored in a single cell to save space. This practice is sometimes still followed today. For example, an employee identification number may tell you the employee number, plant number and business function. That is, 143-01-Acc could identify employee 143, from plant 01, who works in accounting Fot this step, look in the Separated Data sheet that contains 597 rows of employee data. There you will find three columns. EmployeeCode, FirsiName and LasiNarne The EmployoeCode is the combination of four different fietds. Location, EmplD, PlantiD and PayPoniod Each of these fiolds is defined as follows: - Location. The location code shows the location where the employee works. The company operates in eight different countries Aggentina (ARG), Australia (AUS), Canada (CAN), England (ENG), Gormany (GER), Japan (JAP), Moxico (MEX) and the United States of America (USA) The country codes are always three digits and are the first three digits in the EmployeeCode, reading from left to night. - EmplD: The company assigns a random employee identification number from 1,000 10 1,597. Rrading the EmployeeCode from loft to right, the EmpID is the