Hi

I have a spreadsheet pulled into excel with a list of clients. Unfortunately
the entire address appears in one cell and I want to pull the number details
out at the front. Example

13 Blackstock Road
135 Smithy Street
etc.

Is there a way of splitting at the first space (but not the other spaces)

kind regards

Rexmann

PS Using Excel 2003