Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Combining Columns
Hello,
Using Excel 2007. In Column A I have a list of names: A1 Bob A2 Harry A3 Dave etc. In column B I have a list of numbers: B1 14 B2 56 B3 87 etc. I would like to create, in Column C, the combining of what is now in A and B. e.g., C1 Bob 14 C2 Harry 56 C3 Dave 87 How do I do this, please ? Thanks, Bob |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Combining Columns
Hi Bob
This will do it : =A1&" "& B1 That will give you a space between and if not then this : =A1&B1 HTH John "Bob" wrote in message ... Hello, Using Excel 2007. In Column A I have a list of names: A1 Bob A2 Harry A3 Dave etc. In column B I have a list of numbers: B1 14 B2 56 B3 87 etc. I would like to create, in Column C, the combining of what is now in A and B. e.g., C1 Bob 14 C2 Harry 56 C3 Dave 87 How do I do this, please ? Thanks, Bob |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
From OP: Combining Columns
Hi,
Just a quick thanks. Appreciate it. Bob ------------------ On 5/9/2010 12:44 PM, Bob wrote: Hello, Using Excel 2007. In Column A I have a list of names: A1 Bob A2 Harry A3 Dave etc. In column B I have a list of numbers: B1 14 B2 56 B3 87 etc. I would like to create, in Column C, the combining of what is now in A and B. e.g., C1 Bob 14 C2 Harry 56 C3 Dave 87 How do I do this, please ? Thanks, Bob |
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 | |||
Combining columns????? | Excel Worksheet Functions | |||
Combining Columns | Excel Discussion (Misc queries) | |||
Combining columns? | Excel Worksheet Functions | |||
combining columns all the way down | Excel Discussion (Misc queries) |