HOW THE LEN FUNCTION WORKS IN EXCEL
Your productivity as an Excel user depends on how knowledgeable you are with different Excel features.
The LEN function in Excel returns the length of cell content.
The cell content can be text(alphabet), numbers, alphanumeric(a mixture of numbers and text) and spaces (trailing spaces, leading spaces and spaces between words)
This function helps in data cleaning
In this video, I will show you how the LEN function behaves based on the different scenario mentioned above
You can use this function to check the accuracy of a data that comes in a specified form such as phone number, Tax Identification number etc
If you are a beginner in excel, I have a free course that will help you get started here 👇
• Video
How about a template that helps with your bank reconciliation?
Interested, check it out here 👇
/ watchv=bmhnteabf68&list=pl5voikgpgffgqe1ru...
Are you in a business that converts raw materials into finished goods?
Then you will love to check out this template 👇
• 👉RECORD-KEEPING EXCEL TEMPLATE FOR MANUFAC...
Want to learn how to design simple Excel templates and how to use pre-designed templates, check it out here 👇
• 👉HOW TO EASILY TRACK INCOME & EXPENSE TRAN...
#exceltips
#exceltutorial
#excelforprofessionals
#excelforaccountants
#dexcelcoach
#accountingonexcel