Left Formula In Excel allows you to find the character position of a specific character in a given value from the left side of the value. This article describes the Mid formula syntax and process of how to use LEFT formula in Microsoft Excel. Description of Left Formula in Excel LEFT returns the first character or characters in a text string, based on the number of characters you specify.