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