Đang Thực Hiện

MACRO VBA - Name Separation from excel -- 2

Rules to Separate Chinese names

1 Word Take first word as Fname

2 Words Take first word as Fname

3 Words Take first 2 word as Fname

4 Words Take first word as Fname

5 Words Take first word as Fname

Rules for non chinese name

1 Word Take first word as Fname

2 Words Take first word as Fname

3 Words Take first word as Fname

4 Words Take first word as Fname

5 Words Take first word as Fname

Rules to detect chinese names

Must have 3 words

Must contain the variable that has been define by us ie. Wong, yeoh, tan, lim… as per "to recognize chinese words" tab

If both rules are in there only you highlight

Please prepare us a separate button for us to Remove words that we don’t want

Your "find chinese name" has problem.

If I key in "yeo" it will also highlight "yeoh"

If I key in "rizal" it will also highlight "rizalman"

If I key in "wan" it will also highlight "wanie"

The rules should be like this, process should be top to bottom

1. Press - REMOVE - to remove whatever that is being defined by us

2. Press - Detect Chinese Name Button - Highlight whatever that is 3. being defined by us

3. Press - Separate Names. It will separate names according to the rules for (Rules for non-chinese names), once it encounter the highlighted ones, it will separate the name according to the rules of (Rules to Separate Chinese Names)

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem thêm: vba split string by newline, excel vba split string into array, vba split multiple delimiters, vba split string into array of characters, excel vba split string into cells, excel vba array length, excel vba split string into columns, excel vba split function, macro vba name destination cell, excel vba macro worksheet name, example excel vba data separation, check add install excel macro vba, vba open close excel workbook word macro, excel macro directory name, excel macro vba find word

Về Bên Thuê:
( 7 nhận xét ) Bangsar, Malaysia

Mã Dự Án: #14895558

Đã trao cho:

prameswara

as discussed,as discussed,as discussed,as discussed,as discussed,as discussed,as discussed,as discussed,as discussed

$15 USD trong 0 ngày
(315 Đánh Giá)
6.9

25 freelancer đang chào giá trung bình $34 cho công việc này

avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Nex Thêm

$88 USD trong 1 ngày
(126 Đánh Giá)
6.2
sandroshubladze

I am highly qualified and experienced to work for you on this project. Relevant Skills and Experience I am an Excel Expert/VBA programmer. Proposed Milestones $20 USD - Full project.

$20 USD trong 1 ngày
(87 Đánh Giá)
6.3
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet to separate names. Relevant Skills and Experience I have 7 years experience in designing and developing Excel Thêm

$30 USD trong 1 ngày
(112 Đánh Giá)
6.4
dpune

create macro to separate names as per rules Relevant Skills and Experience VBA/Excel Proposed Milestones $80 USD - Completed macro Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my feedbac Thêm

$80 USD trong 3 ngày
(172 Đánh Giá)
6.5
$60 USD trong 1 ngày
(201 Đánh Giá)
6.2
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have all the resources ready to do your project as per your requirement I am very much able to work on this. ***I am read Thêm

$29 USD trong 2 ngày
(94 Đánh Giá)
6.2
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec Thêm

$30 USD trong 1 ngày
(39 Đánh Giá)
4.8
farooq4161

Its my daily job to make scripts like you need, it takes only 4 hour to write script/code that can full fill your requirement. as I already done one of your project. Relevant Skills and Experience I have Master degree Thêm

$30 USD trong 0 ngày
(13 Đánh Giá)
4.5
$25 USD trong 1 ngày
(6 Đánh Giá)
3.7
ank199018

I have 4 years of experience in excel and VBA. Automation of such projects has been my expertise. Kindly ping me so that I can help you with this. Relevant Skills and Experience Advance excel, VBA, Macros. Proposed M Thêm

$25 USD trong 1 ngày
(3 Đánh Giá)
3.1
bestit4u

Hello sir. I 've read your post and so very interested in your job. I 'm sure I can satisfy you with my ability. I 'm working in part of coding and software developing for over 6 years. I have much experiences in d Thêm

$111 USD trong 1 ngày
(3 Đánh Giá)
3.0
shahida772

I am expert in it and am confident I can meet and exceed your expectations. “I can complete your project within the [url removed, login to view] can be decided according to ur desire. Relevant Skills and Experience data entry Propose Thêm

$15 USD trong 1 ngày
(6 Đánh Giá)
2.4
$25 USD trong 1 ngày
(3 Đánh Giá)
2.3
Suzanrawat

Dear Client If you need excellent " Excel spreadsheet, Financial Modelling,Dashboard Reports,Calendar,Schedule,Planer,VBA Script,Excel Forms,Analysis & Reconciliation of large data sets ", I am right person for yo Thêm

$30 USD trong 1 ngày
(1 Đánh Giá)
0.6
$25 USD trong 1 ngày
(1 Đánh Giá)
0.2
slunalo

I am experienced in data handling. I work fast without compromising on quality. This will be a goof opportunity for me to showcase my skills. THANK YOU. Relevant Skills and Experience Database Statistics packages Ms Thêm

$43 USD trong 1 ngày
(0 Đánh Giá)
0.0
madusanka2277

I can complete this within 1 day Relevant Skills and Experience I'm a expert in excel. Proposed Milestones $20 USD - ...............

$20 USD trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
deankiddosam

I will deliver the work on time and on budget with the help of my Computer Techniques for Potential work. Relevant Skills and Experience I will deliver the work on time and on budget with the help of my Computer Tec Thêm

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0