Upper West Sider
New member
My data are organized as follows: first name_middle name_last name
Assume the sample name is entered in cell A1. I have the formula for listing the first name in cell B1: =LEFT(A1,SEARCH("_",A1)-1)
QUESTION: What is the formula for listing the middle name in cell C1?
Thank you.
Assume the sample name is entered in cell A1. I have the formula for listing the first name in cell B1: =LEFT(A1,SEARCH("_",A1)-1)
QUESTION: What is the formula for listing the middle name in cell C1?
Thank you.