View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SeanUK2005 SeanUK2005 is offline
external usenet poster
 
Posts: 2
Default Formula for matching addresses

Hi There,


Can someone help with a formula in excel to find matching addresses between
2 columns? I want to be able to find matching addresses despite the spacing,
upper/lower case formatting and punctuation used in the addresses. Is there a
formula that can help me pick out matching addresses from 2 lists? If there
is, please help me? Email me at ..... Thanks,
Sean