Jan 10 2022 06:42 PM
How to fill E column with cell with data from A to D column. ABCD column will only consist of one data for
Jan 10 2022 07:26 PM
Jan 10 2022 07:56 PM
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.