Google Answers Logo
View Question
Q: Microsoft Excel, Join cells in two colums with one space between ( Answered 5 out of 5 stars,   1 Comment )
Subject: Microsoft Excel, Join cells in two colums with one space between
Category: Computers
Asked by: johnjri1-ga
List Price: $3.00
Posted: 02 Apr 2005 09:46 PST
Expires: 02 May 2005 10:46 PDT
Question ID: 504041
I can't seem to figure this out.  I have data in two colums(A & B) of
a Microsoft Excel spreadshhet that looks something like this.

  A   |   B
xxx   | ooo
xxx   | ooo
xxx   | ooo

I want the data to be combined with one space between them in one
column, so it looks like this:
   A    |   B    |
xxx ooo |        |
xxx ooo |        |
xxx ooo |        |

I hope that example lines up when I post this question.
Having *exactly *one *space between the 'xxx' and 'ooo' is criticaly important.

John J. 
Oh, yeah the version of Excel that came with my Windows 2000 is 10.2614.2625.
Subject: Re: Microsoft Excel, Join cells in two colums with one space between
Answered By: elmarto-ga on 02 Apr 2005 10:21 PST
Rated:5 out of 5 stars
Hi John!
Suppose that cell A1 contains the data "John", and cell B1 contains
the data "Smith". Then, in order to have Excel put "John Smith" in
cell C1, use the following formula for cell C1:

=(A1 & " " & B1)

Copying this formula for all rows of column C will give you the
combined data with a space in between of columns A and B.

Finally, in order to put the new data into column A, you should:

1. Select column C, choose Edit - Copy
2. Select column A, choose Edit - Paste Special...
3. Choose "Values" in the Paste Special... window, click OK. This will
put the values of column C into column A.
4. Finally, erase columns B and C

I hope this helps! If there's anything you don't understand from my
answer, please don't hesitate to request clarification before rating
it. Otherwise, I await your rating and final comments.

Best wishes,

Request for Answer Clarification by johnjri1-ga on 02 Apr 2005 11:36 PST
This question leads me to another question that I will post shortly. 
It regards the output of (A1 & " " & B1),  and Excel's ability to form
a link, as A1 is www. and B1 is

Clarification of Answer by elmarto-ga on 02 Apr 2005 12:28 PST
Thanks for the rating and comments! I'm glad you liked my answer.
Regarding Excel's ability to form links, I'm not sure about it. I
would need to look it up in order to answer your follow-up question.

johnjri1-ga rated this answer:5 out of 5 stars
This answer is *exactly what I asked for. Thanks elmarto-ga!

Subject: Re: Microsoft Excel, Join cells in two colums with one space between
From: jobani-ga on 04 Apr 2005 13:28 PDT

Regarding Excel's ability to form links, try to find the answer.
I will try to get the answer.  Let's see who can get it first. ;)


Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy