| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine and display values in range in 1 cell but skip blank cells
I have a range of data in collumns that I wish to combine into one cell at
location E3 (with comas so it should look like 9,5,10b,4). The range is AE3:BG3 but some cells are blank. The values in the cells are just numbers but I dont want to add them, just display them. Any tips are appreciated. the data looks like this: AG AH AI AJ - 11 9 23 24 18 21 3 4 8 10b 15 16 20 17 11 18 21 4 10b 15 16 20 17 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Chart to display only bars for values that are > 3 & blank cells | Excel Worksheet Functions | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
| display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
| display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
