Fill cell with value

New Contributor


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

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



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.




As variant

=FILTER( A1:D1, A1:D1 <> "" )