Hi, been given an excel spread sheet that has been imported from a DB4
address database.

house number street name town and zip / postcode are all in the same cell.

i.e 1 anystreet anytown zip/postcode,
there are no commas only spaces.

I would like to have first column as house number, next column as street,
next colum as town and final colum as zip/postcode.

One final point is that at the end of each line is about 100 squares. I
thought this would be easy to find and replace with a space but cant even
copy the 'square' into the 'find' to remove all those squares

Hopefully any solution offered will extract just the relevant info and leave
those squares behind.

TIA for all suggestions.