| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to gather non-empty cell info?
Hi,
I have 20 rows of cells which some have text info and some empty. I need a formula to use to add-up these text info separeted with commas excluding the blank cells. Say A1 contains "this", E1 contains "is", and I1 contains "it!". All the remaining cells till AA1 are blank (but can contain info). I need to use a formula in cell AA1 that will gather non empty cells info in row1 and display "this, is, it". The same story applies for row2, row3, ...etc. What should be the formula in AA1:AA20 Thanks J_J |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for empty cell | Excel Worksheet Functions | |||
| Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
![J_J[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
