Count line break in a cell and return the number of line that match with criteria

**manweljs** · 05-30-2018, 11:44 AM

Hi Everyone

I really need help about this case:
Capture1.PNG

as image above, how to return the number of line that contain word "Dimension". in this case the line number is 6.

open for VBA but if can please with a formula.

Regards

**jason.b75** · 05-30-2018, 12:00 PM

Try

=SEARCH("dimension",A2)-SEARCH("dimension",SUBSTITUTE(A2,CHAR(10),""))+1

**tim201110** · 05-30-2018, 12:02 PM

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

**Special-K** · 05-30-2018, 12:05 PM

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

where A1 is original string
and B1 is search sttrng

**manweljs** · 05-30-2018, 01:03 PM

you all are ROCKS guys!!!

Thanks!

Count line break in a cell and return the number of line that match with criteria

LinkBack

Thread Tools

Rate This Thread

Display

Count line break in a cell and return the number of line that match with criteria

Re: Count line break in a cell and return the number of line that match with criteria

Re: Count line break in a cell and return the number of line that match with criteria

Re: Count line break in a cell and return the number of line that match with criteria

Re: Count line break in a cell and return the number of line that match with criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code to insert line break within a cell if specific criteria is met.

Automatically put line break after certain number of Character in a line in Excel

[SOLVED] Count only data within a line break (alt-enter) with specific criteria in adjacent column

Excel 2007 : Line break in a cell after a certain number of characters

[SOLVED] line break / hard return?

line break / hard return?

line break in a cell-Is there a way to get the line break instead of a symbol?

Bookmarks

Bookmarks

Posting Permissions