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
|