How do I merge column contents

[Mike]

Here is my scenario:

I have column A (first name) and column B (last name).
I need to merge the to column a (first and last name).

Ho do I accomplish this?

Using Excel 2003

Sorry for what seems like a stupdily simple question!

Mike Biang
ASP/PHP/ASP.NET

[via135]

hi!

let us assume first name in A1, last name in B1
in C1 enter =A1&B1 which will give the full name!

-via135

Here is my scenario:

I have column A (first name) and column B (last name).
I need to merge the to column a (first and last name).

Ho do I accomplish this?

Using Excel 2003

Sorry for what seems like a stupdily simple question!

Mike Biang
ASP/PHP/ASP.NET

[Doug Kanter]

"Mike" <mbiang@cramerdev.com> wrote in message
news:1140199160.191364.242350@g14g2000cwa.googlegroups.com...
> Here is my scenario:
>
> I have column A (first name) and column B (last name).
> I need to merge the to column a (first and last name).
>
> Ho do I accomplish this?
>
> Using Excel 2003
>
> Sorry for what seems like a stupdily simple question!
>
> Mike Biang
> ASP/PHP/ASP.NET
>

=CONCATENATE(A3," ",B3)

That takes the value in A3, adds a space (shown between quotation marks),
and finally adds the value in B3. If you then copy the formula all the way
down the column, Excel will automatically change the line numbers (A3 to A4,
A5, etc). There's a way to stop that automation, but in this case, you want
it.

This formula has to go in a separate column, but if you have room in the
viewable part of the sheet, you can stick the new column way off to the
right somewhere. Then, copy the new, joined names into whatever column you
want, using Edit, Paste Special, Values.

[Dave O]

No such thing as a stupdi question.

Insert a new column to the left of A: this will be column A, first name
is now column B, last name is now column C. In the first relevant cell
of column A (call it A1), enter this formula:
=B1&" "&C1
This merges the value of B1 and C1 with a space in between.

If you need to convert this to text, highlight all of column A, copy it
to the clipboard, then click >Edit >Paste Special, select Values, and
click OK.

[Doug Kanter]

"Doug Kanter" <ancientangler@hotmail.com> wrote in message
news:jgoJf.392$kg.113@news02.roc.ny...
>
> "Mike" <mbiang@cramerdev.com> wrote in message
> news:1140199160.191364.242350@g14g2000cwa.googlegroups.com...
>> Here is my scenario:
>>
>> I have column A (first name) and column B (last name).
>> I need to merge the to column a (first and last name).
>>
>> Ho do I accomplish this?
>>
>> Using Excel 2003
>>
>> Sorry for what seems like a stupdily simple question!
>>
>> Mike Biang
>> ASP/PHP/ASP.NET
>>
>
> =CONCATENATE(A3," ",B3)
>
> That takes the value in A3, adds a space (shown between quotation marks),
> and finally adds the value in B3. If you then copy the formula all the way
> down the column, Excel will automatically change the line numbers (A3 to
> A4, A5, etc). There's a way to stop that automation, but in this case, you
> want it.
>
> This formula has to go in a separate column, but if you have room in the
> viewable part of the sheet, you can stick the new column way off to the
> right somewhere. Then, copy the new, joined names into whatever column you
> want, using Edit, Paste Special, Values.
>

Oops - type. Should've said "but if you DON'T have room..."

[Mike]

Thanks you guys. You Rock

Mike Biang
ASP/PHP/ASP.NET

[Doug Kanter]

"via135" <via135.23dy6p_1140199802.2965@excelforum-nospam.com> wrote in
message news:via135.23dy6p_1140199802.2965@excelforum-nospam.com...
>
> hi!
>
> let us assume first name in A1, last name in B1
> in C1 enter =A1&B1 which will give the full name!
>
> -via135

He might like to have a space between the names. Can your method do that?

[via135]

hi Doug!

thks for pointing out!

-via135

"via135" <via135.23dy6p_1140199802.2965@excelforum-nospam.com> wrote in
message news:via135.23dy6p_1140199802.2965@excelforum-nospam.com...
>
> hi!
>
> let us assume first name in A1, last name in B1
> in C1 enter =A1&B1 which will give the full name!
>
> -via135

He might like to have a space between the names. Can your method do that?

[Doug Kanter]

You're welcome. How is it done using that method you provided?

"via135" <via135.23e0ym_1140203401.3076@excelforum-nospam.com> wrote in
message news:via135.23e0ym_1140203401.3076@excelforum-nospam.com...
>
> hi Doug!
>
> thks for pointing out!
>
> -via135
>
>
>
> Doug Kanter Wrote:
>> "via135" <via135.23dy6p_1140199802.2965@excelforum-nospam.com> wrote in
>> message news:via135.23dy6p_1140199802.2965@excelforum-nospam.com...
>> >
>> > hi!
>> >
>> > let us assume first name in A1, last name in B1
>> > in C1 enter =A1&B1 which will give the full name!
>> >
>> > -via135
>>
>> He might like to have a space between the names. Can your method do
>> that?
>
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile:
> http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=513761
>