one text body in multiple cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1710912%22%20slang%3D%22en-US%22%3Eone%20text%20body%20in%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1710912%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20a%20paragraph%20split%20between%203%20cells.%20how%20do%20i%20merge%20them%20into%20one%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1710912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

i have a paragraph split between 3 cells. how do i merge them into one? 

1 Reply
Highlighted

@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)