Module 43: LEFT Function

43.1 LEFT Function The LEFT function in Excel can be used when you want to extract characters starting on the left side of a text. It will also extract spaces and special characters. LEFT can also be used to extract digits from numbers, but number formatting will not be extracted. So keep in mind that a currency value, such as £5, will only return a 5. The formula is written as: =LEFT(text, [num_chars]) text - The text from which to extract characters. num_chars - [optio...

Lessons

Find out how we can help train your staff

Or buy an individual course