Sep 24 2020 03:29 PM
i have a paragraph split between 3 cells. how do i merge them into one?
Sep 25 2020 05:09 AM
@fishak06
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)
