The Left and Right functions are one of the most used functions in word processing groups when working on Excel spreadsheets. Based on the function name, you have probably guessed its use, specifically as follows:
The LEFT and RIGHT functions always count each character as 1, whether it's a single byte or a double byte, regardless of the default language setting. Character counts include spaces (spaces) and other special characters.
= LEFT (Text, [num_chars])
= RIGHT (Text, [num_chars])
Explain:
For example, the original text has the content: Download.com.vn. The corresponding return function will be as follows:
| Recipe | Results returned |
| = LEFT ("Download.com.vn"; 8) | Download |
| = RIGHT ("Download.com.vn"; 3) | .VN |
For the main and secondary data tables later, fill in the main data table based on the employee code and data from the 2 secondary tables.
The provisions are as follows : The first 2 characters of the NV Code describe for the job position, the characters at the end describe for the place where employees work. Based on that, we will fill in the formula for calculating each column as follows:
| CV position | = VLOOKUP ( LEFT (C3; 2) ; $ B $ 22: $ C $ 24; 2; 0) |
| Workplace | = VLOOKUP ( RIGHT (C3; LEN (C3) -5) ; $ E $ 22: $ F $ 23; 2; 0) |
In the above formula I have used LEN (Text) as a function to measure the length of a string. Since the Workplace column to look up the column is not 2 or 3 characters long, the length of the string is subtracted from the length of the first characters. To reduce complexity, you can norm for the same type, for example, instead of HN and HCM, you can convert to HAN and HCM, the formula will only be:
= VLOOKUP ( RIGHT (C3; 3) ; $ E $ 22: $ F $ 23; 2; 0)
And here is the results table after you've filled the formula and copied data down the lines below:
That's it, do you find these 2 functions simple? Actually these are the two simplest functions in the text function group. In addition, through this article you also know one more simple function is the LEN function. Please follow the next articles on Download.com.vn to learn more about using other basic functions of Excel!
Oil heaters make noise, leak oil, and do not heat up. These are all problems that arise when using a heater. So what are the causes of these problems? Read our article below!
Master how to assign participants to breakout rooms in Microsoft Teams with this step-by-step guide. Boost meeting engagement, automate assignments, and troubleshoot like a pro for seamless virtual collaboration.
Struggling with Microsoft Teams "Price Error" after the latest pricing update? Discover step-by-step fixes to resolve it quickly, restore seamless collaboration, and avoid subscription headaches. Updated with the newest solutions.
Struggling with Microsoft Teams Background Error Transparency? Discover proven step-by-step fixes for blurry, glitchy virtual backgrounds. Restore perfect transparency in Teams meetings effortlessly. Updated with the latest solutions.
Struggling with Microsoft Teams "Đăng nhập" login error? Discover step-by-step fixes for smooth sign-in. Clear cache, update app, and more – no tech skills needed! Works on Windows, Mac, and web.
Tired of Microsoft Teams Web Error 503 Service Unavailable blocking your meetings? Discover quick, step-by-step fixes to resolve the 503 error fast – no tech skills needed! Clear cache, check status, and get back to collaborating seamlessly.
Stuck with Microsoft Teams Update Error 0x80070002? Discover proven troubleshooting steps to resolve this frustrating issue quickly and get your Teams app updated seamlessly for uninterrupted collaboration.
Tired of Microsoft Teams Error AADSTS50020 blocking your sign-in? Discover step-by-step fixes for user account conflicts, backed by the latest Azure AD solutions. Get back to work fast!
Tired of Microsoft Teams microphone error with no sound? Discover quick, step-by-step fixes for Teams mic not working on Windows, Mac, and more. Restore crystal-clear audio in minutes!
Tired of the Microsoft Teams "Task Management" Error disrupting your workflow? Discover proven fixes like clearing cache, updating Teams, and troubleshooting permissions to get back to seamless collaboration in minutes. Updated with the latest solutions.
Frustrated by the Microsoft Teams 'How to Teams' Help Error? Discover proven, step-by-step solutions to fix it quickly and restore smooth help access. Latest 2026 updates included for seamless teamwork.
Struggling with Microsoft Teams "Room Error" Syncing? This ultimate guide provides step-by-step fixes for Microsoft Teams Room Error Syncing issues, ensuring seamless meetings and quick resolutions. Updated with the latest tips.
Master troubleshooting Microsoft Teams Workflows Power Automate issues with step-by-step fixes for common errors. Get your automations running smoothly – no more frustration! Proven solutions for triggers, permissions, and more.
Struggling with Microsoft Teams "Restart Error" in 2026? Discover proven, step-by-step fixes to resolve the endless restart loop quickly. Clear cache, reset app, and more for seamless collaboration. Get back online fast!
Master how to create breakout rooms in Microsoft Teams before a meeting with this easy guide. Pre-assign participants, boost collaboration, and elevate your virtual sessions effortlessly.
