Multiple Search and Find Problem

[PetraK]

Hi there,

I'm struggling with a multiple search and find. I have 26 separate worksheets that are all in different languages. I am manually putting them into one worksheet (not sure if that's the fastest but I'm a newbie to all this). And then I need to get them all to be in English.

So... for every occurrence of (for example) Lundi, Kedd, Lunes etc etc. I need to change them to Monday.

Or for example people have typed a country name but in many different languages or iterations. For example I need to change USA, U.S.A, US, Amerika to "United States".

I can put the needed information into two columns (e.g. Lundi in A1, Monday in B1, Kedd in A2, Monday in B2... and so on) or into whatever format works best to enable the changes.

I have over 22,000 rows and columns up to ES.

Thanks so so much in advance,
Petra

 

[dmt32]

Dave - sorry for the late reply.

You, my good sir, are a genius!! Thank you SO SO much for your help with this. I cannot thank you enough!! Thank you, thank you, thank you!!!! I am eternally grateful!

Petra

Hi,
Glad solution worked ok for you.

Thankyou for your very generous feedback – it is very much appreciated

Dave