Hi Bosetan,

You need to come out with some logic or process the data as per data pattern.
other wise, how can you tell Excel that which part of name is first name and which one is last name




Regards,
DILIPandey
<click on below * if this helps>