I was wondering if anyone knows how to match similar but not identical cells in excel without specifying the exact match string. For example what formula would match the first word in one cell with the first word in another cell, or say the first 5 characters.
For example, matching the cell "ABC Learning Centres" with "ABC Learning Cents. Ltd" which would be then dragged down for 4000+ companies.
I want it to return a confirmation saying "match" or "true" or something similar so that i know the two columns are reliably matched. I will subsequently use this to match two data bases so I want the match to be as reliable as possible.
Thanks very much for any assistance