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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com