INFORMATICS

The Best

Przełącznik języka

Tools

This Site

Mining

Security

CMS

Hardware

Backup

Windows Server

Databases

Emulators

Powershell

Storage Array

Active Directory

SEO

MSSQL

Antivirus program

Linux

Licznik

3.png0.png4.png4.png5.png9.png4.png
Today61
Yesterday1172
This week2253
This month19495
Total3044594

Visitor Info

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

Who Is Online

2
Online
Lunes, 25 Noviembre 2024 01:09
Está aquí: Home Excel Count line breaks in cell

Count line breaks in cell

Inicio desactivadoInicio desactivadoInicio desactivadoInicio desactivadoInicio desactivado
 

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