Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenating text
Hi, I need to concatenate the first column of every 3 consecutive rows and put the concatenated text in a separate cell.I want to do it till the end of data the excel file. For example,I have this data in 3 different rows in a two column table :- Column1 | Column2 1 2 3 4 5 6 After concatenating,I want the data to appear as follows :- Column1 | Column2 1 | 123 2 | 456 3 | ... 4 | ... 5 | 6 | Can anyone out there please help me out with this ? Thanks Tushar -- tushar_johri ------------------------------------------------------------------------ tushar_johri's Profile: http://www.excelforum.com/member.php...o&userid=30181 View this thread: http://www.excelforum.com/showthread...hreadid=499356 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for concatenating text with results from calculation | Excel Discussion (Misc queries) | |||
Concatenating 3 text columns into a useable date | Excel Worksheet Functions | |||
Concatenating Text and Date in a chart series Name box. | Excel Worksheet Functions | |||
Concatenating text | Excel Discussion (Misc queries) | |||
Moving, deleting, and concatenating text in cells. | Excel Worksheet Functions |