answersLogoWhite

0

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

15y ago

What else can I help you with?

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)


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


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.


Can you call predefined function recursively?

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


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

Formatting.


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 count spaces with the function LEN in Excel?

LEN will count spaces in a cell as well as other characters. So there is no special way needed to count spaces as they will be included. If you are counting what is in cell A3 for example, then you would use the function: =LEN(A3) To count only the spaces in a cell and ignoring other characters, then you could try this approach: =LEN(A3)-LEN(SUBSTITUTE(A3," ","")) It gets the full length and then substracts the length of the text with the spaces removed.