We're in the process of merging data from one database to a new one. The old
database kept addresses as a single field, i.e., 11700 Princeton Pike. The
new database has two fields, one for Number (11700) and one for street
(Princeton Pike). THe total dataset has over 40,000 records and my test data
set has 1,500. Trying to sort in Excel is not possible, as many posters here
have mentioned. Doing Text-to-Columns just 1,500 times is a big enough pain,
let alone 40,000.
Any suggestions?
--
I know enuff to be dangerous.