Hi All,
I am applying the formula for extracting the first, middle and last name. Got the success but if only First name and last name is given then formula does not work. And if also if middle name is not present then it should display X value. Kindly help me or advice me on this. Please find the below details and formula which i have used. Also attaching the excel file named Splitting Names and screenshot for your reference.
Thank you!!
I am applying the formula for extracting the first, middle and last name. Got the success but if only First name and last name is given then formula does not work. And if also if middle name is not present then it should display X value. Kindly help me or advice me on this. Please find the below details and formula which i have used. Also attaching the excel file named Splitting Names and screenshot for your reference.
Thank you!!