Try looking at http://office.microsoft.com/en-us/ex...498501033.aspx

You may need to vary the examples given to suit your exact circumstances but
it gives the underlying techniques



"Vanja" wrote in message
...
Hi,

is it posible to split one cell into two cells. I need it to split street
name (text, one or more words) and street number.

Thanks

Vanja