No need to write formulas to extract first name and last name. Here is a super fast way by using CTRL+H. The same trick can be used to extract user name and domain name from a mail ID.
File used in this tutorial – https://1drv.ms/x/s!Akd5y6ruJhvhvTPIrUd2QVh1ro7x?e=SyaAMr