On Wed, 02 Feb 2005 16:53:30 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:
Martin How did you merge two cells and retain data from both the original cells?
I looked for 'merge cells' in HELP and got:-
Microsoft Excel places only the upper-leftmost data in the selected
range into the resulting merged cell. To include all data in the range
in the merged cell, copy the data into the upper-leftmost cell within
the range. For information about how to copy the data, click .........

Jim's idea about the "Merge Across" button will cause a message in every row
of the range selected.

Yeah, i discovered that

To retain both cells' data you should add the data to one cell rather than
merge cells.
In E1 enter =C1 & D1 or =C1 & " " & D1

That's great Gord - did the job
=C1 & " " & D1 was better as I needed some space between Dist and
numbers

One learns something new every day
Regards
Martin
©¿©¬