View Question
Q: Microsoft Excel, Join cells in two colums with one space between ( Answered ,   1 Comment )
 Question
 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
 ```Hi, 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 etc... 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. Regards, John J. Oh, yeah the version of Excel that came with my Windows 2000 is 10.2614.2625.```
 ```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, elmarto``` 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 website.com.``` 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. Cheers! elmarto```
 johnjri1-ga rated this answer: `This answer is *exactly what I asked for. Thanks elmarto-ga!`
 ```johnjri1-ga, Regarding Excel's ability to form links, try www.mrexcel.com to find the answer. I will try to get the answer. Let's see who can get it first. ;) Jobani```