Good day world
I have text in a cell that looks as of it is all in one line but as soon as you press F2 in that cell and then Enter the cell opens and you can see the text is in multiple lines
For instance if the text is in cell E2 I have place a formula [=LEN(E2)-LEN(SUBSTITUTE(E2,CHAR(10),""))+1] in cell F2 and then the formula brings back the number 1
As soon as I press F2 and enter in cell E2 the formula in cell F2 shows a lot more that 1, it shows all the lines that is actually in the cell
I have tried a macro “”sentkey”” to do the F2 and Enter procedure
But it does not work
Is there another way to do this ?
Bookmarks