use several cells from differnt areas as one row (or column)

Hi Marcol,

thanks for your formula suggestion which works;

the idea is to "straigten" broken row (which is splitted over 2 areas) into one compact row (see fresh attachement);

BTW, isn't there a way to simplify formulas of these types ?

=IF(COLUMNS($B:D)>COUNT($B16:$C16;$D15:$E15);"";MID(SUBSTITUTE(" "&$B16&" "&$C16&" "&$D15&" "&$E15;" ";REPT(" ";255));255*COLUMNS($B:D);255)*1)

Best, Miro