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
|