Excel Formulas and Functions Tutorial - LEN Formula

In this Excel Formulas and Functions Tutorial we will show you how to use the LEN formula in Excel.

There are times when you need to get the number of characters within a cell in Excel. Thankfully this is very easy to do with Excel’s LEN (Length) formula!

You can use the LEN function in Excel to count all characters in a cell, including letters, numbers, special characters, and all spaces.

The LEN function can be used as a data cleansing technique to find leading or trailing spaces or can be nested with other TEXT functions as we show in this Excel Formulas and Functions Tutorial.
--------------------
DOWNLOAD THIS EXCEL WORKBOOK:
Click here to download the Excel workbook & practice over at our blog:

------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 Microsoft Excel video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...

🔥 OUR BEST EXCEL RESOURCES 🔥

------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MyExcelOnline

[jerrypapula]

=RIGHT(A3, LEN(A3)-(LEN(LEFT(A3, 3))+LEN(MID(A3, 4, 3)))), maybe its a long shot but it works

[wayneedmondson]

Thanks Kyle.. how about =RIGHT(LEN(A3)-6) (copy down). That would do it.. assuming you always have 6 leading characters. You could also do it with the IF function, but this method can handle more than one variation of the number of characters after the first 6. Thanks for the videos.. always learn something new. Thumbs up!

[TheJoeman]

I was wondering if anyone can help me with text project I am working on. I have a first name, middle name, last name, street no, street name, city, state, and zip all in one cell. I don't want to use the text to columns feature, I need a formula to break up each category. I've done some research and couldn't find anything that is all in one cell. If you have the time can you help me with this set up? Thanks, Joe from Michigan
Show less