Combine Text from 2 columns into 1

  • Thread starter Thread starter dscmm
  • Start date Start date
D

dscmm

Is there a way to move text from column B and paste or insert into column A
behind existing text; without retyping?
 
Insert a helper column to the left of column A and enter the following
formula in cell A1, changing the row number to match your worksheets layout:

=A1&" "&B1

Copy the formula down as far as necessary, and the select the cells with the
formula and select copy. With the cell pointer in A1, click EDIT in the
menu, select PASTE SPECIAL and click the VALUES option button. Click OK to
exit the dialog box and complete the copy.

At this point you can delete columns B and C as they are no longer necessary.
 
dscmm said:
Is there a way to move text from column B and paste or insert into column A
behind existing text; without retyping?
Click to expand...

Kevin- Thanks for the info on =A1&" "&B1- It worked; however brings another
question--

Is there a way to force the text from column B to insert below column A text
when it is copied?
 
=A1 & CHAR(10) & B1


Gord Dibben MS Excel MVP

Kevin- Thanks for the info on =A1&" "&B1- It worked; however brings another
question--

Is there a way to force the text from column B to insert below column A text
when it is copied?
Click to expand...
 
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

Split column contents (de-concantenate) 7
retain custom date format "text" when pasting or reformatting data 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
combining column contents ? 4
combining text 4
Text to columns 2
Want to link a cell of numbers with a cell of text & can sort 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0

Back
Top