Question: how to extract data from a text string in excel?
Answer: To extract the leftmost characters from a string, use the LEFT function in Excel. To extract a substring (of any length) before the dash, add the FIND function. Explanation: the FIND function finds the position of the dash. Subtract 1 from this result to extract the correct number of leftmost characters.