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

  • Thread starter Thread starter Phillips
  • Start date Start date
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
 
I figured it out!

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

Thanks though!

Phil
 
Back
Top