| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining two text columns into one
I would like to have a formula in column C that would look at column A and
Column B and combine both entries . There are blanks where indicated. A B C Bob Bob Jack Jack Dick Dick Nancy Nancy Mary Mary Can anyone help me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining two text columns into one
=A1&B1
Copy down. "ferde" wrote: I would like to have a formula in column C that would look at column A and Column B and combine both entries . There are blanks where indicated. A B C Bob Bob Jack Jack Dick Dick Nancy Nancy Mary Mary Can anyone help me? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining two text columns into one
Or
=A1&" "&B1 if you want a space between the contents of the two source cells. -- David Biddulph "JMB" wrote in message ... =A1&B1 Copy down. "ferde" wrote: I would like to have a formula in column C that would look at column A and Column B and combine both entries . There are blanks where indicated. A B C Bob Bob Jack Jack Dick Dick Nancy Nancy Mary Mary Can anyone help me? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining two text columns into one
There are two types of solution for ur question
sol I : =A1&" "&B1 in this solution if u want a space between both words u can use space sol II : = CONCATENATE(A1," ",B1) This is the second solution usually we can use as per u r data standard no confusions in this. what ever text u want to add between both the cell u can. try this and reply me c u bye -- Name : K.Prasad Inventory Manager CRYSTALGALLERY DUBAI "ferde" wrote: I would like to have a formula in column C that would look at column A and Column B and combine both entries . There are blanks where indicated. A B C Bob Bob Jack Jack Dick Dick Nancy Nancy Mary Mary Can anyone help me? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combining two text columns into one
Yes. However, if the sample data is representative, there is only one entry
per row. If a space is added to the result, this could screw up any subsequent lookups or conditional comparisons. Perhaps the best solution that would satisfy the most possibilities: =TRIM(A1&" "&B1) "David Biddulph" wrote: Or =A1&" "&B1 if you want a space between the contents of the two source cells. -- David Biddulph "JMB" wrote in message ... =A1&B1 Copy down. "ferde" wrote: I would like to have a formula in column C that would look at column A and Column B and combine both entries . There are blanks where indicated. A B C Bob Bob Jack Jack Dick Dick Nancy Nancy Mary Mary Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| How Do I use COUNTIF Combining the Text from 2 Columns | Excel Worksheet Functions | |||
| Combining multiple columns of text | Excel Discussion (Misc queries) | |||
| combining 2 pieces of text from 2 columns | Excel Worksheet Functions | |||
| Combining text from multiple columns into 1 | Excel Discussion (Misc queries) | |||
Linear Mode
