Hello to all,
This is my Raw Data, I have to extract firstname, middlename and lastname in seperate column.
First Name = =LEFT(A16,SEARCH(" ",A16))
Last Name = =RIGHT(A17,LEN(A17)-SEARCH(" ",A17))
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Last Name is not working Properly. Please help me out.
This is my Raw Data, I have to extract firstname, middlename and lastname in seperate column.
First Name = =LEFT(A16,SEARCH(" ",A16))
Last Name = =RIGHT(A17,LEN(A17)-SEARCH(" ",A17))
Full Name | First Name | Middle Name | Last Name |
Shivya Jain | Shivya | Jain | |
Shweta Jain | Shweta | Jain | |
Mohan Prakash Sharma | Mohan | Prakash Sharma | |
Juhi Chawla | Juhi | Chawla | |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Last Name is not working Properly. Please help me out.