MrExcel Publishing
Your One Stop for Excel Tips & Solutions

text to column

Posted by Amanda on March 02, 2001 11:25 AM

I'm trying to divide a street address so that it can
be sorted by street name, then number.
I eventually need to be able to join these back
together and bring them into a MSAccess database.
I've tried text to column but it only works
when the string lengths match up well, by chance.

Posted by Aladin Akyurek on March 02, 2001 11:47 AM

The procedure described at


should be applicable to the street address question.