Assuming there will always be one and only one space in the Director field (between the first and last name), the following should work:
Hope that helps,
It works perfectly! Thanks!
You are welcome!!
What if there is a duplication in initial names, how to make additional letter to initial so it prevent duplication?