I posted this last week but did not recieve a reply. Since then i have not found a solution.
I have a list with two columns and 1000 rows, i want to use this to replace items found in another list as follows.
If the string in A1 is found replace it with B1. And do this for about 1000 items in another sheet of nearly 20,000 rows. Seems simple enough? Maybe this can already be done with find replace tools found in excel, i cant find them though....
any help would be great :D
I have a list with two columns and 1000 rows, i want to use this to replace items found in another list as follows.
If the string in A1 is found replace it with B1. And do this for about 1000 items in another sheet of nearly 20,000 rows. Seems simple enough? Maybe this can already be done with find replace tools found in excel, i cant find them though....
any help would be great :D