How to exclude the middle name (alphabet) and split the full name as 'First Name' and 'Last Name' on separate columns

Help Studio
, ,
6

However, in my case
I need to use an input excel file that has fullname
and after the data manipulation is sent into another excel file (output). Tried a couple of times…
and it looks like I am missing something important. Please have a look at this screen shot

image.png
image.png607×598 66.1 KB

image.png
image.png437×713 76.6 KB

image.png

In the output excel file everything is the same, except the names are split as firstName and LastName

Thank you a lot for your help!

image.png
image.png335×510 42.3 KB

Employee_New.xlsx (11 KB)