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...

How to copy paste
How to paste photo in resume - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Pi copy and paste - Guide
How to compare two Excel sheets with varying data ✓ - Excel Forum
Macro to compare two excel sheets ✓ - Excel Forum

2 responses

Answer 1 / 2

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

Answer 2 / 2

babu
Dec 24, 2009 at 06:25 AM

Dear sir thank you very much that formula is very much useful for me..

Similar discussions

Can no longer paste text into insta

Deleted Message icon

Comparing Two Excel Sheets and copying like data to third sheet

Copy/paste

VBA Compare 2 sheets and output difference to 3rd sheet

Similar discussions

Subscribe To Our Newsletter!