Is it possible to count the length of the text in the second line in a cell?

[kwfine]

Hello,

In a single cell, there are two lines of texts:

Hello
World

I had used Len((Sheets("arbitrary").cell(1,1).value), and Excel told me that it was 11.

I want to know the length of the word, World, in the second line in the cell.

Could you help please?

Thank you.

[kasan]

Hi,
Basically you need to find character position where new line starts and ends.
In case cell A1 contans text (two line cell):
"ABC
World"

Find new line symbol within this cell:

Please Login or Register  to view this content.

This should give you 4.
Then just use

Please Login or Register  to view this content.