Sep 24 2020
i have a paragraph split between 3 cells. how do i merge them into one?
Sep 25 2020
Let's say the three cells are B1 to B3.
In another cell, enter the formula =CONCAT(B1:B3) or if you have an older version of Excel, =CONCATENATE(B1,B2,B3)