I think that this will be mostly a manual effort.

Whatever you do, save often and make plenty of backups. One mass change and a
save and you may lose any corrections you've already verified.

You could do this:
select the range
edit|replace
what: - (hyphen)
with: (leave blank)
replace all

32-59 85 Ave
will become
3259 85 Ave

but if that hyphen is used in other portions of the address:

1234 North-West Highway
These may change, too.

As for the spaces, this is more trouble:

32 59 85 Ave
would become
325985Ave
Not what you had in mind.



Lisleb wrote:

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

--

Dave Peterson