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

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