Split the cell

[Vanja]

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

 

[BRob]

Try looking at http://office.microsoft.com/en-us/excel/HA011498501033.aspx

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

 

[Vanja]

Thanks

Try looking at http://office.microsoft.com/en-us/excel/HA011498501033.aspx

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