You tell the MID formula where to start with the start_number and then it grabs the specified number of characters to the right of the start_number. I used the LEFT formula to get the first word. I had it look in cell A1 and grab only the 1st character from the left.