Is there anyway to merge two cells of data so that the data from both cells is kept??
A Angus Sep 14, 2004 #1 Is there anyway to merge two cells of data so that the data from both cells is kept??
D Debra Dalgleish Sep 14, 2004 #3 You can combine the data in another cell by using the & operator. For example, with text in cells A2 and B2, enter the following formula in cell C2: =A2 & B2
You can combine the data in another cell by using the & operator. For example, with text in cells A2 and B2, enter the following formula in cell C2: =A2 & B2