The Left function on Excel let’s you extract a substring from a string, beginning at the most left character.
This a a really handy function and I use it more often than I thought I actually would.
The syntax for this forumula is
Text is the string you want to extract from( that is the cell reference that holds your text string) and Number_Of_Characters is the number of letters you want to extract from the full string.
As always it’s way easier with an example… or two.
As you can see we have extracted the first 9 letters from the left of the strings in cells A2 to A4
So the results of the formula can be seen in cells B2 to B4, where the first 9 characters have been returned (including spaces) as these are classed a characters as well.
Give this a go and let me know what you have used it for….