I have some data in excel 03 where addresses are written as 32-59 85 Ave or
32 59 85 Ave. How do I get Excel to correct this data to remove the dash or
the space to express the address as 3259 85 Ave.
Thanks.
--
lisle