Can I read ABC Junior College Final Exam Marks on EtoBox?
ABC Junior College Final Exam Marks by sjoshi143 is a document available to read on EtoBox.
What is ABC Junior College Final Exam Marks about?
Here are the steps to extract first name and last name from the full name: 1. Split the full name into an array using the space as the delimiter 2. The first element of the array will be the first name 3. The last element of the array will be the last name For example, if the full name is "John Doe": 1. Split on space: ["John", "Doe"] 2. First name = array[0] = "John" 3. Last name = array[array.length-1] = "Doe" So the formula would be: =LEFT(A1,FIND(" ",A1)-1)
- Author
- sjoshi143
- Language
- EN