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: 18.216.204.44
- Browser: Unknown
- Browser Version:
- Operating System: Unknown
Who Is Online
4
Online
Miércoles, 19 Febrero 2025 00:14
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