How to copy paste

[Closed]
Report
-
 babu -
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...
Related:

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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
Dear sir thank you very much that formula is very much useful for me..