Fill cell with value

%3CLINGO-SUB%20id%3D%22lingo-sub-3056691%22%20slang%3D%22en-US%22%3EFill%20cell%20with%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3056691%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22yusnazery_0-1641868652411.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F338544i364C2FD893DB8FB0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22yusnazery_0-1641868652411.png%22%20alt%3D%22yusnazery_0-1641868652411.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHow%20to%20fill%20E%20column%20with%20cell%20with%20data%20from%20A%20to%20D%20column.%20ABCD%20column%20will%20only%20consist%20of%20one%20data%20for%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3056691%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

yusnazery_0-1641868652411.png

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
=CONCAT(A1:D1)
or maybe =concatenate(A1:D1) if you are running an old version

@yusnazery 

 

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.

alannavarro_0-1641873289018.png

 

@yusnazery 

As variant

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