Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting number of lines in a CELL
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting number of word in a cell | Excel Discussion (Misc queries) | |||
Counting number of characters in a cell | Excel Worksheet Functions | |||
How do I make a cell with vertical lines for number entry? | Excel Discussion (Misc queries) | |||
How do I make lines appear after entering a number in a cell? | Excel Discussion (Misc queries) | |||
Counting the number of letters in a cell | Excel Discussion (Misc queries) |