Levenshtein for strings

[antros48]

Hi all,
I need to combine a lot of different excel workbooks that each one of them have the same column titles e.g. on one workbook the A1 = "Name", B1 = "Surname", C1 = "Phone" etc. But some workbooks have some differences of characters for instance instead of A1 = "Name" to have A1 = "Name_" etc.
I created a master workbook that contains on the first row the titles that i want to apply to all of the various workbooks: Name, Surname etc. I used the Levenshtein code that I found online to compare the strings with each other and select the one that has the best result e.g. for the Name column to replace any variances of Name_ or Name) with the correct title that exists in my master file i.e. Name, but I haven't been able to get the results so far that i wanted.
Is there any other way to do this task?
In case that I decide to take the manual way I will have to open these workbooks one by one and check each title to make sure that these are correctly typed.
Any help appreciated.

[scottiex]

what is the aspect that is slowing you down? I guess opening the files.

If so - you could get some code to open all the worksheets and record the data in A1 (or whatever cell) from every sheet
then you can use our fuzzy match to correct them and maybe some further correction by sight to make sure it is correct.

Then you can use similar code to write the value back to the sheets

a simple open files loop is

Please Login or Register  to view this content.