In a given cell, how can I count how many carragereturn/line feeds are imbedded?

P

Phillips

If I have a cell (A3) and want to see how many line feeds are in it, how do
I caunt that? How abount any other charater if it is not the same?

Thanks
Phil
 
P

Phillips

I figured it out!

It is
=(LEN(A3)-LEN(SUBSTITUTE(UPPER(A3),CHAR(10),"")))/LEN(CHAR(10))

Thanks though!

Phil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
How to make the shading look uniform around a double spaced line in MS Word? 0
Cumulative formula for word table 0
How to have two tables on same line? 1
Creating a Search using a combo box and then creating a report. 4
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Outlook 2021 export question 0
Macro to Select text from a point given to a specific word 2

Top