Merging the text of 2 cells into 1.

DawnM

Hello, is there a way to merge the text of 2 different cells into 1 please?

I have tried several versions of this but I get different error messages. 

 

=(([cell]1) &” “&([cell]2)  

 

Thankyou.

Chris H

Try this

 

=[Task Name]1 + ", " + [Task Name]2

 

Change task name 1 and 2 to the cells you want