Thanks to both of you!!

Rochelle

"JE McGimpsey" wrote:

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 ,
"Rochelle" 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