Complete Excel Guide

You will find all the information regarding Excel.

Wednesday, 23 August 2017

LEN Function

LEN Function
It is used to find the length of the text or number.

Syntax: LEN(text)
Example: =LEN("India")
Result: 5





Assignment:
1. Find the length of your name?
2. Find the length of "January"?
Posted by Unknown at 07:21
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: finding text length in excel, how to find length of text in excel, len function, len function in excel, len( ) example, len() formula, length of excel

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Archive

  • ▼  2017 (37)
    • ►  September (8)
    • ▼  August (29)
      • NOW & TODAY Functions
      • TIME Function
      • DATE Function
      • Date & Time Functions List
      • TEXT Function
      • SUBSTITUTE Function
      • REPLACE Function
      • MID Function
      • PROPER Function
      • FIXED Function
      • T Function
      • SEARCH Function
      • REPT Function
      • RIGHT Function
      • TRIM Function
      • UPPER Function
      • LOWER Function
      • LEFT Function
      • LEN Function
      • Find Function
      • EXACT Function
      • DOLLAR Function
      • CONCATENATE Function
      • CODE Function
      • CLEAN Function
      • CHAR Function
      • BAHTTEXT Function
      • Text Functions
      • Types of Functions in ExcelText Function  Date ...
Hit Counter
Ethereal theme. Powered by Blogger.