• Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

Excel’s LEN Function: Basic Knowledge You Need to Know About LEN Function

0 Comments

Hello everyone, to count the length of characters or strings in Excel, we will use the LEN function. Besides counting the number of characters in a string, how can we apply and combine the LEN function to fully exploit its power? Please follow the article below.

WHAT IS THE LEN FUNCTION?

The LEN function in Excel counts all characters in a cell and returns the length of the string. The structure of the LEN function is very simple as follows:

=LEN(Text)

Where Text is the place where you want to count the number of characters.

To understand more, let’s enter some basic commands into Excel as follows:

=LEN(“abc”): The result will return 3, because the text string here is abc and it consists of 3 characters. Note that because they are letters, we must enter them in double quotes. Excels LEN Function 1

Excels LEN Function 2Similarly, if we try to enter =LEN(11256), the result returned will be 5.

Or we can refer to another cell by entering =LEN(A1). Excels LEN Function 3

Excels LEN Function 4

Now we will go into some applications of the LEN function for calculation.

COUNT CHARACTERS IN MULTIPLE CELLS

Suppose we want to count the total number of characters in cells A1, B1, C1, then we use the LEN function as follows:

=LEN(A1)+LEN(B1)+LEN(C1) Excels LEN Function 5

Excels LEN Function 6

Or we can use the SUM function combined with the LEN function to count, and the formula will be implemented as follows:

=SUM(LEN(A1),LEN(B1),LEN(C1)) Excels LEN Function 9

Excels LEN Function 10

Note that the LEN function will also count the spaces, as you can see in this example where there is a space between the numbers. The result returned will be 7, including the space character.

Now if we want to exclude counting this space, we will do it in two cases:

Count characters by removing leading and trailing spaces.

Very simple, you will combine with the TRIM function to count with the syntax as follows:

=LEN(TRIM(A1))

Count characters by removing all spaces in the entire string.

Combining with the SUBSTITUTE function, we get:

=LEN(SUBSTITUTE(A1,” “,””)) Excels LEN Function 11

So I have just introduced some tips and tricks with the LEN function in Excel, hoping it will be useful to you. Good luck!

8
60 Views
3 Simple Ways To Convert Xlsx To XlsPrev3 Simple Ways To Convert Xlsx To XlsApril 7, 2023
How to separate positive and negative numbers in ExcelApril 8, 2023How to separate positive and negative numbers in ExcelNext

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
Top rated products
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
Products
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.