View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] KenCJohnston@gmail.com is offline
external usenet poster
 
Posts: 1
Default Address Format Problem

Hey,
I've got a list of a couple thousand names and addresses.
Unfortunately somewhere along the fields "Address Number" and "Street
Name" where merged together. Whoever merged them forgot to add the " "
Character inbetween. Now I have a bunch of addresses like "1234Main
St.","1111Grand" and "250E 10th St.". Any idea how I can fix these? I
figure I need to use a macro because I've been playing around with the
text string functions and can't find any thing that will work.

KCJ