How do you use len in excel?



How do you use len in excel?..

Answer / Pankaj Prakash Ram

As mentioned earlier, the LEN function in Excel returns the number of characters in a text string. You can use it in formulas like this: =LEN(A1) to get the length of the text in cell A1.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is the use of pivot table in excel?

1 Answers  


How can I enter the current date into a cell so it does not change from day to day? When I use the now function, it always shows the current date?

1 Answers  


How do you delete a row?

1 Answers  


What is the trim function?

1 Answers  


How would you format a cell?

1 Answers  


What is spreadsheet and its functions?

1 Answers  


How do you lock a cell in excel?

1 Answers  


What is the use of text formula in excel?

1 Answers  


How can we convert excel to word?

1 Answers  


How do you merge two excel sheets and remove duplicates?

1 Answers  


How do I make a list of names in excel?

1 Answers  


What is mean by autosum?

1 Answers  


Categories