One way:

In place (e.g., A1 -> A1:B1):
Choose Data/Text to Columns. Click "Delimited". Click Next. Check the
Space checkbox, click Finish.

By formula:

A1: Kingstreet 23
B1: =LEFT(A1,FIND(" ",A1)-1)
C1: =MID(A1, FIND(" ",A1)+1, 255)

In article <3CD72DB4-B572-4557-950E-226ECD54CF67@microsoft.com>,
"Rochelle" <Rochelle@discussions.microsoft.com> wrote:

> Hi!
>
> I would like advice on how to separate the names and the numbers of an
> address written in one column into the name and the number in two separate
> columns.
> In otherwords "Kingstreet 23" must become "Kingstreet" and "23."
>
> Can anyone help with a function that can do this?
>
> Thanks in advance,
>
> Rochelle