| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concate a range ignoreing blank cells
=A1 & A2 & A3 & A4 & A5 & A6
It does not matter if A4 is empty or not. If it is empty, it will be ignored?? -- Gary''s Student - gsnu200857 "Nigel" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range naming cells with blank cells through coding | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
