Count Number of Lines Within a Cell

[seguin85]

Hi,
Is there a way to count the number of lines within a cell? I found a formula and VBA to count the line breaks which is great, but I need something that will also count when a wrapped text goes to the next line.

It may be important to note that the cells are merged...

Thanks in advance!

 

[seguin85]

I didn't think it would be that difficult of a task, but I am very appreciative of the feedback

 

[jasonb75]

I didn't think it would be that difficult of a task

It's not that difficult if the merged cells are removed from the equation.
You could try educating the person that asked you to do this in the art of designing sheets without merged cells, although such a task is usually as impossible as working with merged cells ?

 

[seguin85]

It's not that difficult if the merged cells are removed from the equation.
You could try educating the person that asked you to do this in the art of designing sheets without merged cells, although such a task is usually as impossible as working with merged cells ?

Thanks, I ended up reformatting the sheet to not have merged cells to help with this issue. It doesn't look quite as pretty as it used to, but it functions much better now.