D
dscmm
Is there a way to move text from column B and paste or insert into column A
behind existing text; without retyping?
behind existing text; without retyping?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin B
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.
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.
D
dscmm
dscmm said: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?
G
Gord Dibben
=A1 & CHAR(10) & B1
Gord Dibben MS Excel MVP
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?