| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excal Concatination of cells that are not empty
I am trying to concatinate a row of 30 cells. Some of these are empty or
blank. I want to combine these 30 cells where they are not blank. I have tried several functions, however the limit is 7 functions in one cell. How can I complete this task? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trendlines to ignore empty cells | Charts and Charting in Excel | |||
| How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
| CountIF cells are not empty | Excel Discussion (Misc queries) | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
Threaded Mode
