If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|