RegEx

[zcy9079]

Hi all,

I have a list of cells in the following format. 

Alice 12345 [Senior Analyst]

Please could anyone kindly help how can i extract 12345 to a new column "Employee ID"and Senior Analyst to a new column "Job title". the number of characters for the job title is not fixed, but it will always comes with []. Employee ID is always 5 digit

Many thanks for your time!!

thanks

Claire 

[atcodedog05]

Hi @zcy9079 

I have updated my solution.

[atcodedog05]

Hi @zcy9079 

Here is how you can do it.

Workflow:

Hope this helps : )