MACRO VBA - Name Separation from excel

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)