In Progress

Excel script or macro

Hello,

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.

Thanks

Skills: Data Processing, Excel, Script Install, Visual Basic

See more: 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

About the Employer:
( 67 reviews ) munich, Germany

Project ID: #533412

Awarded to:

northwolves

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

$40 USD in 0 days
(59 Reviews)
5.2

14 freelancers are bidding on average $51 for this job

svet63

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 days
(84 Reviews)
6.8
xamdam91

Looking forward to working with you...

$40 USD in 0 days
(67 Reviews)
6.1
agihcam

Please check PMB.

$30 USD in 1 day
(40 Reviews)
5.2
nmppatel

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 days
(25 Reviews)
4.9
piyushdpatel

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

$70 USD in 2 days
(13 Reviews)
4.9
refractocd

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

$50 USD in 1 day
(15 Reviews)
4.1
syslogic

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

$100 USD in 3 days
(3 Reviews)
3.3
cheungkc

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 More

$40 USD in 1 day
(7 Reviews)
3.2
dicadio

Please check your PMB, thanks

$35 USD in 1 day
(2 Reviews)
2.6
excelmodeler

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 days
(2 Reviews)
1.4
snid73

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

$30 USD in 1 day
(0 Reviews)
0.0
ZeusPaez

Please see PMS Best Regards

$30 USD in 1 day
(0 Reviews)
0.0
overflow636

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

$30 USD in 0 days
(0 Reviews)
0.0
percentit

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

$90 USD in 3 days
(1 Review)
0.0