| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count the number of Lines in a "wrap text"-cell
Hi I try to count the number of Lines within a „wrap text“-cell. It would be nice to have a solution without VBA programming. Tanks a lot for your help Michael -- MichaelS_ ------------------------------------------------------------------------ MichaelS_'s Profile: http://www.excelforum.com/member.php...o&userid=26406 View this thread: http://www.excelforum.com/showthread...hreadid=522984 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count the number of Lines in a "wrap text"-cell
Hi!
If the lines were created using CHAR(10) "hard returns" (key combo ALT+ENTER) you could count those chars: =LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(10),""))+1 Have no idea how to do it if the cell was simply formatted to wrap text. Biff "MichaelS_" wrote in message ... Hi I try to count the number of Lines within a "wrap text"-cell. It would be nice to have a solution without VBA programming. Tanks a lot for your help Michael -- MichaelS_ ------------------------------------------------------------------------ MichaelS_'s Profile: http://www.excelforum.com/member.php...o&userid=26406 View this thread: http://www.excelforum.com/showthread...hreadid=522984 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count the number of Lines in a "wrap text"-cell
Thank you very much for your help. My problem is solved. Michael -- MichaelS_ ------------------------------------------------------------------------ MichaelS_'s Profile: http://www.excelforum.com/member.php...o&userid=26406 View this thread: http://www.excelforum.com/showthread...hreadid=522984 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
