Excel 2007 : Excel 2007 How to move trailing numbers into the adjacent column

Hi
I have a column of business names. Some of them have trailing numbers.
Kangaroo 935
Kangaroo Express 926
Rite Aid Store 11360
Short Stop 68

I want to move these to an adjacent column.

Kangaroo 935
Kangaroo Express 926
Rite Aid Store 11360
Short Stop 68

Previously these had a # which I converted to a comma copied to a text file and then recreated an excel file.
Any help would be greatly received.
Also please tell me how to mark the question as solved as I had an issue solved the other day.

Mark