View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sarah Sarah is offline
external usenet poster
 
Posts: 231
Default Deleting duplicate house numbers

Hello,

we extract information for street addresses, sometimes we receive house
number duplicated example:

123 123 Main Street

Does anyone know of a way to delete the first number so we just have the
correct address of 123 Main Street?

Thanks