Combine Text from 2 columns into 1
 

Is there a way to move text from column B and paste or insert into column A
behind existing text; without retyping?

Combine Text from 2 columns into 1
 

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


"dscmm" wrote:

Is there a way to move text from column B and paste or insert into column A
behind existing text; without retyping?

Combine Text from 2 columns into 1
 

"dscmm" wrote:

Is there a way to move text from column B and paste or insert into column A
behind existing text; without retyping?

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?

Combine Text from 2 columns into 1
 

=A1 & CHAR(10) & B1


Gord Dibben MS Excel MVP

On Tue, 25 Mar 2008 12:24:01 -0700, dscmm
wrote:



"dscmm" wrote:

Is there a way to move text from column B and paste or insert into column A
behind existing text; without retyping?

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?