LEN is one of the middle text functions in Excel that each one customers must have in their set of capabilities. The characteristic will return the length of a designated textual content string. You may wonder while you may use this?. But, once you start to do any kind of statistics manipulation in Excel you'll quickly recognize how beneficial it virtually is.
So how does it work?. LEN will return EVERY individual in a textual content string. So, all textual content, areas, punctuation and numbers will all be included in the count number of characters in query.
Let's examine an example or two. The syntax for the system is
=LEN(Text)
See an instance text string under:-
Excel is terrific.
Applying the above formula the end result might be 17
Here is every other instance:-
howtoexcelatexcel
Applying the above formulation the end result might be 17
So, simply how will this be beneficial? If you do any facts paintings with Excel, mainly with records uploading or records cleansing this feature may be precious. Imagine you've got a set of data to import from one database gadget to every other. The new device will now not be given a call discipline longer than positive character duration.
You know the fields that have regulations within the new database, but your vintage machine facts did not have such controls. With this records you can without difficulty use Excel LEN function as a way of figuring out the call data that have been too long in length.
You can insert a extra column to calculate the duration of the text string. The records can be taken care of using this greater columns that contains the consequences of the LEN function. Easy.
Here are the unique steps to sporting out such an workout
Open your Excel document
Insert a column to the proper of the sphere you desire to measure
Enter a column name in this case 'call duration'
Place the Excel cursor within the first mobile under your column identify
Formulas Tab
Function Library
In the search for a characteristic container type LEN
Hit Ok
Click the mobile that incorporates the text string you need to carry out the individual count number
Hit Ok
The result of the count number of the textual content string can be displayed, all you want to do is reproduction the formula on your other cells in the column.
You can quick try this with the aid of deciding on the first cell in your column with the formula, scroll down the column to the ultimate cellular in the column you need to examine.
Hit SHIFT-Click within the final cell to pick all of them.
Press CTRL+D to fill along with your formulation all of the manner down the column.
You now have the remember of the string of characters in your selected call facts and may type them to identify those which can be over the brink of what's allowed in the new database system.
Excel is often thought of as a variety of cruncher and that is its restrict. LEN is one example of Excels constructed in capabilities that may be used that will help you work smarter and faster to solve real problems with data.
