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