I have a set of First Names and Last names in my application in below format.
When i am using text to columns, i am getting output as
But, I need output as below :
Can someone help me to get the required output? or else please let me know at least, is it possible or not...