Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I create an excel formula to count lines within cells?
How do I create an excel formula that will count entries in a range of cells incluing lines within each cell?
I have a simple database which tracks leave. Some cells have several dates in them eg c4 might have only one date but c5 might have 3 dates if someone took 3 days leave. At them moment all I can manage is to count the number of cells with an entry...What I really need to to count each date which appears in the range.
3 Answers
- Frank PytelLv 41 decade agoFavorite Answer
You defenitely need to parse the entrys. Access should be storing these dates as text. You should be able to use mid() to parse the string. You will have to have the mid() in several cells and tell it when to start and when to stop.
place the text in a1. Place the mid() in 9 or 10 cells with the first cell looking at the first 10 characters or so in the string, the next would take 11-20, 21-30, etc.
God Bless
Frank Pytel
- 1 decade ago
You need to parse the lines. Did they use Alt+Enter to create the separate lines? You might be able to copy the cells into Word, then copy back again into Excel (try a sample sheet first). This will turn soft returns within a cell into individual cells.
- Anonymous1 decade ago
I think you mean the COUNT function. You can see example in Excel's Help files.
If not, can you be more specific?
