I need a batch replace tool for Microsoft Excel that should work in the following way.
instead of replace string by string I want to replace all string pairs in one bacth automatic action
1. I have one excel sheet with English expressions
2. I have an Excel Replacement sheet with String pairs. Left column Original Expression; Right colums "Replacement expression". I need replace all expressions in file with the replacements expressions.
3. Now I need macro or script, that goes trough the file and search for the strings from the translation sheet and replace the strings by the replacemet string in a bacth procedure
4. The replacement strings have both English and Chinese characters. This is important and must work
5. The translation sheet must be editable. Means no hardcode, I must be able to edit (add or change string pairs)
I found some programms on the web like "Batch replace for Excel". But it dont work properly and do not support chinese.
Please find enclosed. A) Sample of Original file. B) Sample of replacement file C) Sample OUTPUT FILE
When you make your bid please tell me the timeline. Time is very important. I want it quick and reliable.
14 freelancers are bidding on average $51 for this job
VBA developer since 1997. I have developed a spreadsheet to work with Japanese characters, so Chinese won't be a problem. Will do within 1-2 days. Regards, Svet.
Hi I have developed several VBA scripts and have knowledge of advanced algorithm skills which makes my scripts performance the best. Please see PM for sample of my work. Thanks