Text is the cell containing the original text string. The first two arguments of this MID formula are crystal clear: MID( cell, SEARCH(" char", cell)+1, SEARCH (" char", cell, SEARCH (" char", cell)+1) - SEARCH (" char", cell)-1) To extract text from the left of a string, you use the Excel LEFT function: Extract substring from start of string (LEFT)