How to copy paste

Closed
babu - Dec 19, 2009 at 06:28 AM
 babu - Dec 24, 2009 at 06:25 AM
Hello,
In my excel sheet in A row i have Names and in B row i have only address, i want to merg both the row in as singl row can it posible?? any formula or macro?? plz help me...

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 19, 2009 at 09:43 PM
suppose the data starts from row no. 2 with row 1 having column headings

in C2 or any empty cell in the same row copy this formula

=A2&" "&B2


copy c2 down
0
Dear sir thank you very much that formula is very much useful for me..
0