ps. The formula would be for a column:
=a1&a2&a3&....


Bev wrote:

I have between 6 and 10 pieces of data which I wish to copy from the column
they are in, into a single cell (which has been merged to make it larger and
more visible to see) The data which is just a series of numbers or letters
(or a combination of both) do not need to be re-used from this merged cell
Can you help please?

Bev
--
Bev

--

Dave Peterson