Excel 2007 : Merge two Columns with a space

Hi guys

My first post here!

I have two columns in my Excel worksheet - A & B. Column A contains numbers (not consecutive) and column B contains text.

What I want to do is merge column A with column B and put a space between the merged number and text.

E.g.

Column A Column B
234 XYZABC

I want a new column to contain 234 XYZABC. There are about 800 rows.

I hope I've explained this adequately!

Cheers

John

Thanks very much for the reply. It worked a treat and as you can tell, I'm a newbie to Excel.

Cheers

John