Tell the LEN Feature in Microsoft Excel
Must you’ve ever desired to try to salvage the change of characters in a line of textual issue material, that you can even spend Microsoft Excel to pause so, which capability of the LEN feature. Right here’s the fashion to make spend of it.
What Is the LEN Feature?
The LEN feature is an easy calculation feature that counts the full characters in a given textual issue material string, along with numbers, letters, particular characters, and areas. The feature title (LEN) is shorthand for size, as the feature output affords the full size of a textual issue material string as a host.
To give you an example, let’s take that an Excel workbook comprises a cell with the following textual issue material:
Right here is an example textual issue material string containing 56 characters!
The textual issue material string contains areas, textual issue material, numbers, and a outlandish persona, and has a size of 56 characters. Must you esteem to substantiate this calculation, that you would be in a position to well spend LEN to pause so.
Tell the LEN Feature in Microsoft Excel
Unlike varied Excel capabilities, the LEN feature is amazingly straight forward to make spend of. It contains handiest one argument—the textual issue material string that you esteem to calculate. That you just can even either space this within the formulation straight, or that you can even take a look at with a cell that contains the textual issue material string.
To illustrate, the following formulation calculates the size of a textual issue material string contained in cell A1. Must you esteem to make spend of this formulation yourself, change the cell reference with your possess.
=LEN(A1)
As previously mentioned, that you can even also spend LEN to calculate the size of a textual issue material string written into the formulation straight the utilization of the example formulation below.
=LEN("Right here is an example textual issue material string.")
That you just can even change the example textual issue material with your possess, but you’ll net to surround the textual issue material string in quote marks. Alternatively, space the textual issue material in a separate cell (with out quote marks), then spend the cell reference for that cell in your formulation to salvage out the size as a change.