=LEN(F1)-LEN(SUBSTITUTE(F1,CHAR(10),""))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"fbhcah" wrote in message
...
Hi,

I have a cell which has a number of lines within it. I want the number of
lines it has to come into another cell. Is there any formula or macro for
that?

Eg:
A1 content is:
first line
second line
thrid line
Once I use the formula/macro, say A2 will have value 3.

Thanks a lot,
fbhcah