Przełącznik języka
Tools
Mining
Security
CMS
Hardware
Backup
Windows Server
Databases
Emulators
Powershell
Storage Array
Active Directory
SEO
MSSQL
Antivirus program
Linux
Licznik
Visitor Info
- IP: 3.138.125.86
- Browser: Unknown
- Browser Version:
- Operating System: Unknown
Who Is Online
4
Online
24.11.2024 05:01
Count line breaks in cell
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