Pulling numerical field from a string... in excel sheet

aligahk06The simple action is to use the Data text to column tool where the separator is =

and another separator is the space character, then removing other unneeded columns.

You can find the "Text to column" tool here in the Data tab:

If you use Excel 2013 or later version, there is another solution can be achieved using Flash Fill. Type manually the first code extracted as you need, then select the whole column and click Flash Fill, you can find Flash Fill under the fill menu in the Home tab as shown in the following image:

Otherwise, using formulas will add an advantage, which is automatic update if the original data change. If the employee code is stick to 5 characters you can use the following formula:

=MID(A1,SEARCH("employee_code = ",A1)+16,5)*1

If the employee code varies from 5 characters, we may need to add another part to the formula above to solve this. Please let me know if you need it.