Read my response.


Gord Dibben MS Excel MVP

On Mon, 10 Dec 2007 12:04:00 -0800, MDN wrote:

Thank you. Is is possible to Concatenate a large range of cells ? I have 75
cells that I want to put together. Does that mean I'll have to enter each
number into the formula or is there a way to do a range?


"Marcelo" wrote:

try to use concatenate
assuming that you have one data base

a b

1 Many to
2 Things do
3
4 =a1&" "&a2&" "&b1&" "&b2

hth


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"MDN" escreveu:

Hello

I'd like to copy the contents from a group of cells and then paste all of
those contents into one cell on a different worksheet. How can I do this?