ExcelBanter - formula to apply concatenation to successive rows of data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula to apply concatenation to successive rows of data (https://www.excelbanter.com/excel-worksheet-functions/100970-formula-apply-concatenation-successive-rows-data.html)

Devo

formula to apply concatenation to successive rows of data

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

tim m

formula to apply concatenation to successive rows of data

=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?

Ron de Bruin

formula to apply concatenation to successive rows of data

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

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

"Devo" wrote in message ...
How do I apply concatenation to successive rows of data, using a formula?

All times are GMT +1. The time now is 10:43 AM.