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

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" <(E-Mail Removed)> wrote in message
news:hs6oom$821$(E-Mail Removed)...
> 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

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