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.191.223.123
- Browser: Unknown
- Browser Version:
- Operating System: Unknown
Who Is Online
1
Online
30.04.2024 04:42
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