formula to apply concatenation to successive rows of data

How do I apply concatenation to successive rows of data, using a formula?

=CONCATENATE(A1,B1)

Then just copy the formula down.

(Tough to know exactly what youa re after without more info, where does your
data start, what kind of sample data are we looking at?)

"Devo" wrote:

> How do I apply concatenation to successive rows of data, using a formula?

See also this page
http://www.mcgimpsey.com/excel/udfs/multicat.html


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Devo" <Devo@discussions.microsoft.com> wrote in message news:B26C72D7-B1ED-43F0-BFDA-7476A0D60389@microsoft.com...
> How do I apply concatenation to successive rows of data, using a formula?