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