Merging Data.

[Angus]

Is there anyway to merge two cells of data so that the
data from both cells is kept??

 

[Frank Kabel]

Hi
not without using VBA

 

[Debra Dalgleish]

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