Take a look at Data Text to columns.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi, we have some cells which contain numbers and words
eg. house number and
street name. We need to split the cell so that the
numbers are in one column
and the street names are in another column. Is this
possible? Thanks
.