Excel script or macro


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.


Habilidades: Processamento de dados, Excel, Instalação de Script, Visual Basic

Veja mais: excel macro chinese characters string, string find c, string b, some search string, microsoft web expression, microsoft expression web, me excel, find chinese translation, excel 16, chinese english translation excel macro, macro script excel, web expression 4, microsoft macro, microsoft expressions 4, expression web 4.0, chinese characters, macro, macro excel, macro + excel, hardcode, expressions, edit chinese, do excel, search web excel, quick excel

Acerca do Empregador:
( 67 comentários ) munich, Germany

ID do Projeto: #533412

Concedido a:


As a top expert of Excel,it seems too easy for [url removed, login to view] PMB please.

$40 USD em 0 dias
(59 Comentários)

14 freelancers estão ofertando em média $51 para esse trabalho


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.

$100 USD in 2 dias
(84 Comentários)

Looking forward to working with you...

$40 USD in 0 dias
(67 Comentários)

Please check PMB.

$30 USD em 1 dia
(40 Comentários)

I am an excel VBA expert. I have complete many projects on GAF in excel skill.I will complete this project in few hours.

$50 USD in 0 dias
(25 Comentários)

Hi This is Piyush Patel I have 4.5+ yrs of Exp in VB6,,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$70 USD in 2 dias
(13 Comentários)

I can do it in 1 day. Please refer to PM.

$50 USD em 1 dia
(15 Comentários)

am a senior developer from the Munich area who could create this string-replacement function (which supports UTF-8 encoding).

$100 USD in 3 dias
(3 Comentários)

Hi I propose to provide an Excel 2003 utility file where user can supply names of input file, replacement file and their respective sheet names. Editing of the replacement file is not within this assignment but all Mais

$40 USD em 1 dia
(7 Comentários)

Please check your PMB, thanks

$35 USD em 1 dia
(2 Comentários)

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

$80 USD in 2 dias
(2 Comentários)

I have more than 10 years experience in VBA Macro. I can finished it by today if you choose me.

$30 USD em 1 dia
(0 Comentários)

Please see PMS Best Regards

$30 USD em 1 dia
(0 Comentários)

Looking forward to working with you. Ive programmed many excel macros and this one seems just like them.

$30 USD in 0 dias
(0 Comentários)

Hi, I have extensive Excel development experience. Please check PMB. thanks

$90 USD in 3 dias
(1 Comentário)