Hi!
I need to replace some data in Excel workbook on several tabs, but cannot figure a formula to cover all tabs. Can someone help?
In my Excel I might have the same name (and I know they are really the same eventhough written differently) spelled in various ways like :
John Smith
John Smith Jr
John Smiith
Kohn Smith
I have on summary tab all names (some of those need to be replaced as well, since they are duplicates or misspelled) and about 150 tabs holding names in one column and some other data in other columns.
If I will create a sheet that has old and new values like the one below, can someone help me to create a formula for my workbook to replace all old values with new values in all tabs?
Old value New value
John Smith John Smith
John Smith Jr John Smith
John Smiith John Smith
Kohn Smith John Smith
Furthermore, how to delete ALL tabs in the end of cell? I am able to delete doubles with TRIM-formula, but there is still one space left after all.
Thanks before hand
I need to replace some data in Excel workbook on several tabs, but cannot figure a formula to cover all tabs. Can someone help?
In my Excel I might have the same name (and I know they are really the same eventhough written differently) spelled in various ways like :
John Smith
John Smith Jr
John Smiith
Kohn Smith
I have on summary tab all names (some of those need to be replaced as well, since they are duplicates or misspelled) and about 150 tabs holding names in one column and some other data in other columns.
If I will create a sheet that has old and new values like the one below, can someone help me to create a formula for my workbook to replace all old values with new values in all tabs?
Old value New value
John Smith John Smith
John Smith Jr John Smith
John Smiith John Smith
Kohn Smith John Smith
Furthermore, how to delete ALL tabs in the end of cell? I am able to delete doubles with TRIM-formula, but there is still one space left after all.
Thanks before hand
