Fill cell with value

Question

How to fill E column with cell with data from A to D column. ABCD column will only consist of one data for&nbsp;

alannavarro · Answer

yusnazery&nbsp;&nbsp;You can use the formula textjoin = (,TRUE,A1:D1)The first option is the delimiter you are going to use to join the text (we are going to skip it), then if you want to skip blanks as true and finally the text range that you want to join in one cell.&nbsp;

mtarler · Answer

=CONCAT(A1:D1)or maybe =concatenate(A1:D1) if you are running an old version

sergeibaklan · Answer

yusnazery&nbsp;
As variant
=FILTER( A1:D1, A1:D1 &lt;&gt; "" )

Forum Discussion

Fill cell with value

3 Replies

Resources