| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to apply concatenation to successive rows of data
How do I apply concatenation to successive rows of data, using a formula?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
| What formula captures specified rows of data? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Hybrid Mode
