Can someone please help me. I was working on a data base in excel and in the
address boxes had abbreviations such as Dr for Drive and St for Street and
Gr for Grove. I thought I would use replace to put in the full words. After
I had done it I saved the file, but then found that it had put Drive, and
Street etc in every instance following Dr or St even if it was in the middle
of a word. I now have a huge data base with lots of errors and I have to fix
it quickly. Can someone please tell me if there is a way I can fix it. There
are 18,000 entries and I have already changed about 6000 rowsl but it is
taking forever....HELP