Merging cells?

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

If I have data in Column A and data in Column B and want to put the data in
Column B along with the data in Column A and I have to do this with a
thousand rows is there anyway I can do this without doing one cell at a
time? Therefore have all my data in Column A only. I have Vista with Excel
XP
 
in c1 put

=A1 & " " & B1

if that looks right copy it down as far as the data goes. Then Select
all the filled cells in C, copy and then Paste Special in A, picking
Value from the list. If everything looks the way you want, Save the file.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Reference Formula Help 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Help to copy information from one row at a time to another sheet 1
sorting two columns of merged cells 1
Help with a procedure to make things easier 6
Having Blank Cells, etc. ? 1

Back
Top