Combining the Contents of Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Mahan - 02 Feb 2008 13:28 GMT

I could really could use some help to combine the contents of Column (A )
and (B) into Column (C) I'm not very knowledgeable with Excel or using
formulas. The example I have is: First Name in column A Last name in
Column B I want to put First and Last name into one Column C Thanks

Signature

Richard K Mahan Sr

"Imagination is the Father of Creativity"

Reply to this Message

Max - 02 Feb 2008 14:06 GMT

In C1: =A1&" "&B1
Copy down

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>I could really could use some help to combine the contents of Column (A )
>and (B) into Column (C) I'm not very knowledgeable with Excel or using
>formulas. The example I have is: First Name in column A Last name in
>Column B I want to put First and Last name into one Column C Thanks

Reply to this Message

Richard Mahan - 02 Feb 2008 14:55 GMT

Thanks but I must be doing something wrong since the only thing that shows
up in Column C is the formula.

> In C1: =A1&" "&B1
> Copy down
>>I could really could use some help to combine the contents of Column (A )
>>and (B) into Column (C) I'm not very knowledgeable with Excel or using
>>formulas. The example I have is: First Name in column A Last name in
>>Column B I want to put First and Last name into one Column C Thanks

Reply to this Message

Dave Peterson - 02 Feb 2008 15:09 GMT

Select column C
Format|Cells|Number tab
choose General

Then reenter the formula (and drag down)

> Thanks but I must be doing something wrong since the only thing that shows
> up in Column C is the formula.
[quoted text clipped - 16 lines]
> >>
> >> "Imagination is the Father of Creativity"

Signature

Dave Peterson

Reply to this Message

Richard Mahan - 02 Feb 2008 19:13 GMT

I'm afraid I'm just not getting it ! I have been trying for over and hour. I
just can't seem to combine the first name amd last name into one column. as
I said before, I just started to working with excel and have a lot to learn
but I appreciate the help.Thanks, Richard

> Select column C
> Format|Cells|Number tab
[quoted text clipped - 24 lines]
>> >>
>> >> "Imagination is the Father of Creativity"

Reply to this Message

Dave Peterson - 02 Feb 2008 19:33 GMT

Maybe you can try it again and keep track of your steps.

Then (if it fails), post back with your steps and any problem at any step.

> I'm afraid I'm just not getting it ! I have been trying for over and hour. I
> just can't seem to combine the first name amd last name into one column. as
[quoted text clipped - 33 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 02 Feb 2008 19:35 GMT

ps.

You could be looking at formulas, too.

In xl2003 and below, you can use:
Tools|Options|View tab|uncheck Formulas.

If Formulas is already unchecked, then this wasn't the problem.

You could also use a shortcut to toggle this setting:
ctrl-~ (control-backquote, to the left of the 1/! key on my USA keyboard)

Signature

Dave Peterson

Reply to this Message

Richard Mahan - 03 Feb 2008 12:52 GMT

For the benefit of any other Newbies to Excel 2007 Like my self, It took
this Demo from from Microsoft to solve my problem. copy and paste the link
below.

http://office.microsoft.com/en-us/excel/HA102503791033.aspx. A
Demo is worth a thousand words

> ps.
>
[quoted text clipped - 51 lines]
>> >
>> > Dave Peterson

Reply to this Message