Combine Text from 2 columns into 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dscmm - 13 Mar 2008 13:42 GMT

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

Reply to this Message

Kevin B - 13 Mar 2008 14:00 GMT

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.

Signature

Kevin Backmann

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

Reply to this Message

dscmm - 25 Mar 2008 20:24 GMT

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

Reply to this Message

Gord Dibben - 25 Mar 2008 21:34 GMT

=A1 & CHAR(10) & B1

Gord Dibben MS Excel MVP

>> Is there a way to move text from column B and paste or insert into column A
>> behind existing text; without retyping?
[quoted text clipped - 4 lines]
>Is there a way to force the text from column B to insert below column A text
>when it is copied?

Reply to this Message