Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel - data merger in two cells
I have a data spread in a column upto 1000 cells (A1 to A1000). I need to merge data from two consecutive cells (for exapmle A1 and A2; A3 and A4, and so on) into one cell for all of them. I would appreicate if a formula is avilable in Excel. thanks Babu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel - data merger in two cells
Sub AAAA()
Dim i As Long Application.DisplayAlerts = False For i = 1 To 1000 Step 2 Cells(i, 1).Resize(2).Merge Next Application.DisplayAlerts = True End Sub -- Regards, Tom Ogilvy "babu" wrote in message ... I have a data spread in a column upto 1000 cells (A1 to A1000). I need to merge data from two consecutive cells (for exapmle A1 and A2; A3 and A4, and so on) into one cell for all of them. I would appreicate if a formula is avilable in Excel. thanks Babu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merger SQL Query into EXCEL | Excel Discussion (Misc queries) | |||
Excel merger | Excel Discussion (Misc queries) | |||
mail merger in excel | Excel Discussion (Misc queries) | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
excel - data merger in two cells | Excel Programming |