Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to concate acroos a rage ignoring any blank values in cells,
for example I wold like to concate A1 to A6 but if there is no value in A4 ignore that cell Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concate a range ignoreing blank cells | Excel Programming | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Determine if range has NO Blank Cells without looping through each cell in range | Excel Programming | |||
How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
How do I get zeros to stay in front of a # when using the concate. | Excel Worksheet Functions |