| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine two text columns | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| How do I combine two columns of text to 1 as in 1st name surname | Excel Discussion (Misc queries) | |||
| How do you combine two columns to one? | Excel Discussion (Misc queries) | |||
Linear Mode
