answersLogoWhite

0


Best Answer

The LEN function returns the length of the specified string.

=LEN(text)

text is the string to return the length for.

EXAMPLE:

=LEN(word) will return the value of 4.

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the function of pre-defined function LEN in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the dialog box containing predefined functions available in Excel?

The Insert Function dialog box.


How do you easily select predefined functions in Excel?

Click on the function bar at the top of the worksheet (looks like fx).


Which dialog box contains a list of predefined functions available in excel?

The Insert Function dialog box contains a list of predefined functions available in Excel. Click the Insert Function box, and in the search bar, type in a description of what you want to do. Click OK, and then browse through the functions. If you already know the name of a function, choose it from the box.


A predefined formula a formula that excel has already built for you. that performs calculations by using specific values in particular order?

It is a function


What Formula do you use for excel to see how many characters are in a cell?

The LEN function counts the amount of characters in a cell. For example: =LEN(A3)


Can you call predefined function recursively?

Guess you meant: can a recursive function call predefined functions? Answer: sure, why not.


Where you could find Text length in Excel?

You use the LEN function. Say you had some text in cell A2 and you wanted to find out how long it was, then you would type the following formula: =LEN(A2)


What feature in excel stores predefined format options?

style


What is a Generic Function in c plus plus?

Predefined functions are built-in functions that perform standard operations and that generally do not depend on any classes. A predefined void function is simply a predefined function that has no return value. An example of a predefined void function is the abort() function which typically has the following signature: void abort(void);


How do you draw line without using any predefined function?

That won't happen, you have to have a predefined putpixel (or something like that) function.


What are predefined set of characteristics that can be applied to cell contents in excel?

Formatting.


How do you apply conditional formatting in excel 2003 based on number of characters in a cell?

Use the LEN function to count how many characters are in the cell. If you want to evaluate cell C23, use LEN(C23)=6.