I need help to write a VBA find and replace code for Excel
Budget: £10 – £20 GBP
As part of my daily job I am processing and normalising spreadsheets. It requires significant manual work. I want to write a series of macros that can be applied to a single worksheet and that carry out the following operations:
1. Finds and replaces accented characters with non accented
ÿ – y
ô, ó,ò, ő, ö – o
é,è,ê,ë – e
á, à, â, ä – a
ú, ù, û, ü – u
ñ – n
í. Ì. Ï – i
ç, č – c
š - s
ß - ss
2. Deletes certain characters
° ' " ,
3. Find and replace certain words and phrases
Vendanges Tardives = VT
Selection des Grains Nobles = SGN
GG => Grosses Gewachs
1er Cru => Premier Cru
2eme cru => Deuxieme Cru
3eme cru => Troisieme Cru
4eme cru => Quatrieme cru
5eme cru => Cinquieme cru
This is probably the work of seconds for a VBA developer but unfortunately that is not me, hence this request. Thank you in advance.
1. Finds and replaces accented characters with non accented
ÿ – y
ô, ó,ò, ő, ö – o
é,è,ê,ë – e
á, à, â, ä – a
ú, ù, û, ü – u
ñ – n
í. Ì. Ï – i
ç, č – c
š - s
ß - ss
2. Deletes certain characters
° ' " ,
3. Find and replace certain words and phrases
Vendanges Tardives = VT
Selection des Grains Nobles = SGN
GG => Grosses Gewachs
1er Cru => Premier Cru
2eme cru => Deuxieme Cru
3eme cru => Troisieme Cru
4eme cru => Quatrieme cru
5eme cru => Cinquieme cru
This is probably the work of seconds for a VBA developer but unfortunately that is not me, hence this request. Thank you in advance.