LEFT function


Returns the number of characters from the left of a string.



=LEFT( text[num_chars] )


required arguments:

text The text string.


optional arguments:

[num_chars] The maximum number of characters that is returned.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.