Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to merge cell please help
Please help
i had a excel workbook with few thousand lines of name, address A 1 Name 2 Adrress1 3 Adrress2 4 5 Name 6 Adrress1 7 Adrress2 I need to merge it into some thing like this A B 1 Name Name, Address1, Address2 2 Adrress1 3 Adrress2 4 5 Name Name, Address1, Address2 6 Adrress1 7 Adrress2 Please help with a VBA code or Marco Thanks Best Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to merge cell please help
in B1
=IF(MOD(ROW(B1),4)=1,A1&","&A1&","&A3,"") then drag fill down the column. -- Regards, Tom Ogilvy "Chuong Nguyen" wrote: Please help i had a excel workbook with few thousand lines of name, address A 1 Name 2 Adrress1 3 Adrress2 4 5 Name 6 Adrress1 7 Adrress2 I need to merge it into some thing like this A B 1 Name Name, Address1, Address2 2 Adrress1 3 Adrress2 4 5 Name Name, Address1, Address2 6 Adrress1 7 Adrress2 Please help with a VBA code or Marco Thanks Best Regards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to merge cell please help
Tom - do you have a typo in your formula? Don't you want to reference cell A2
in the formula, as follows: =IF(MOD(ROW(B1),4)=1,A1&","&A2&","&A3,"") Cheers - Jeff "Tom Ogilvy" wrote: in B1 =IF(MOD(ROW(B1),4)=1,A1&","&A1&","&A3,"") then drag fill down the column. -- Regards, Tom Ogilvy "Chuong Nguyen" wrote: Please help i had a excel workbook with few thousand lines of name, address A 1 Name 2 Adrress1 3 Adrress2 4 5 Name 6 Adrress1 7 Adrress2 I need to merge it into some thing like this A B 1 Name Name, Address1, Address2 2 Adrress1 3 Adrress2 4 5 Name Name, Address1, Address2 6 Adrress1 7 Adrress2 Please help with a VBA code or Marco Thanks Best Regards |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to merge cell please help
"Chuong Nguyen" wrote in message ... Please help i had a excel workbook with few thousand lines of name, address A 1 Name 2 Adrress1 3 Adrress2 4 5 Name 6 Adrress1 7 Adrress2 I need to merge it into some thing like this A B 1 Name Name, Address1, Address2 2 Adrress1 3 Adrress2 4 5 Name Name, Address1, Address2 6 Adrress1 7 Adrress2 Please help with a VBA code or Marco Thanks Put this into B1 and copy it downward as needed: =IF(A4="",A1&", "&A2&", "&A3,"") Cheers, Joerg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to merge many cell to one cell with keeping all data | Excel Worksheet Functions | |||
How to merge one cell from many workbooks to one cell on one work | Excel Worksheet Functions | |||
Merge cell & Copy Data from different cell | Excel Discussion (Misc queries) | |||
Merge Cell | Excel Programming | |||
How do I merge 2 cells for ex. DE (1 cell) & 01234 (2 cell) into . | Excel Discussion (Misc queries) |