Dear All,
I have an excel sheet of text string like....
Cell A1 .... employee_code = 25147 and trans_code=16....
Cell A2 .... employee_code = 25112 and trans_code=16....
Cell A3 .... employee_code = 18512 and trans_code=16.... and so on ...
i want to pull employee code from above string in corresponding an excel cell like B1: 25147 B2:25112 and B3:18512
Note - before employee code there is a string and after =16 there is string.
Request for any formula or assistance for solution...
Regards,
aligahk06
I have an excel sheet of text string like....
Cell A1 .... employee_code = 25147 and trans_code=16....
Cell A2 .... employee_code = 25112 and trans_code=16....
Cell A3 .... employee_code = 18512 and trans_code=16.... and so on ...
i want to pull employee code from above string in corresponding an excel cell like B1: 25147 B2:25112 and B3:18512
Note - before employee code there is a string and after =16 there is string.
Request for any formula or assistance for solution...
Regards,
aligahk06