How to use LEN function in excel

Excel version in which LEN function can work:

LEN function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010.

About LEN function in excel:

LEN function calculate the number of character in a selected cell and returns the number of characters in the given text string. Len will also count numbers but number formatting will not be considered. This function considers space as one character.

Syntax for LEN :

=LEN(text)

Parameters:

text [Required]: text string for which length is to be calculated.

Using LEN function:

Len function can be used to get the number of character in a text string. This function can also be used in Excel VBA code.

LEN function

Leave a Comment