INFORMATICS

The Best

Przełącznik języka

BUY COFFEE

If you like the website and want to support the project!

Postaw mi kawę na buycoffee.to

Tools

This Site

Mining

Security

CMS

Hardware

Backup

Windows Server

Uncategorised

useful sites

Databases

Emulators

Powershell

Storage Array

Active Directory

SEO

MSSQL

DNS

Antivirus program

Linux

Foto

Licznik

3.png4.png6.png0.png9.png0.png1.png
Today44
Yesterday1099
This week4951
This month42191
Total3460901

Visitor Info

  • IP: 10.1.78.165
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online

4
Online
Thursday, 29 January 2026 00:40
You are here: Home Excel Count line breaks in cell

Count line breaks in cell

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

To count total lines in a cell, you can use a formula based on the LEN, SUBSTITUTE, and CHAR functions.

In the example shown, the formula in A1 is:

=LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(10),""))+1

Search