Hi Bob,


Thanks for the help. Either Im executing the formula incorrectly or it
doesnt work. I have two list lists of Postal Addresses. I need to extract the
ones that match but cant seem to find a proper formula as the Postal
Addresses arent in the same format. In other words, some are in Upper and
some lower case and some have 1 or more spaces inbetween and some have
punctuation eg in list 1 i have 23 Jones Lane and in list 2, I have 23
joneS Lane. This is a match but no formula will pick it out unless they are
identically spaced and the upper and lower case all match. Can you help? I
just need to pick out the common postal addresses in two lists so we can use
the information. Please help if u can? Thanks alot for the help. Cheers, Sean
"SeanUK2005" wrote:

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