Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 77
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 694
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 77
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Text from 2 Columns into 1 then Deleting the 2 Columns sleepindogg Excel Worksheet Functions 5 September 19th 08 12:36 AM
Combining columns????? rhcpcf Excel Worksheet Functions 1 January 15th 08 09:03 PM
Combining Columns Petri M Excel Discussion (Misc queries) 2 November 30th 05 02:41 PM
Combining columns? sus Excel Worksheet Functions 1 November 18th 05 09:13 PM
combining columns all the way down sparkroms Excel Discussion (Misc queries) 3 July 8th 05 08:28 PM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"