123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computers >> View Article

Using The Left Formula In Excel

Profile Picture
By Author: Excel Everest
Total Articles: 9
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Do you happen to have well meaning people in your office who just don't get Microsoft excel??

In their effort make life as easy for you as possible, they end up making it a lot more complicated?

Here's an example that might seem all too familiar to you. Your boss has just finished reviewing the sales (in 2009) of each person in your sales team. Based on their experience, and his gut feel, he has assigned sales targets for everybody in 2010. These are expressed as percentages of sales achieved in 2009. This data is shown below. He wants you to get at the actual sales targets.

microsoft excel

In order to compute the sales target, you'd ideally want to multiply the numbers in the second column with those in the third. Except that you can't.

You can't do this because your boss has entered each data point as a text (" 180% of Last Year"). So what you're going to have to do is manually look up each number, and enter it as a formula in the adjoining cell.

Now, ...
... there are only nine people in this hypothetical example, but imagine a sales team that comprises of say, 200 people. Problem? Late night at the office? Frustration all round?

Not with Microsoft excel 2007 tutorial, there isn't!

Excel has this rather nifty formula called "left". And left is as left does.

Left (the formula) lets you take a cell and extract a certain number of characters from the left. So, for example "=Left(A3,4)" would extract the first four characters out of whatever happens to be in cell A3.

You can see where we're going with this, can't you?

All you have to do is what's shown in the picture below, and drag throughout the entire problem. Voila, problem solved!

microsoft excel

That's a fairly simple application of the Left formula. And yes, Excel has a "Right" version as well. Not to mention a "Mid".

How have you gone about using these formulas? Any particularly delectable use cases? Do let us know!

About Author:

ExcelEverest.com sells an interactive Microsoft excel lesson plans that's built right into an Excel file. It covers 41 topics and has 155 exercises, 339 buttons, and 87 embedded videos. For more related articles please visit http://www.exceleverest.com/blog/.

Total Views: 297Word Count: 386See All articles From Author

Add Comment

Computers Articles

1. Scraping Dan Murphys Liquor Products Details Data
Author: FoodDataScrape

2. Blue Wizard Liquid Drops 30 Ml 2 Bottles Price In Lahore
Author: bluewizard.pk

3. How Does Blockchain Resolve Data Privacy And Security Issues For Businesses?
Author: Severus Snape

4. Scrape Quick-commerce Data From Deliveroo Hop Uae
Author: FoodDataScrape

5. Web Scraping Quick-commerce Data From Noon Minutes Uae
Author: FoodDataScrape

6. Helical Insight: Best Open Source Data Visualization Tool In 2025
Author: Vhelical

7. Scrape Top Selling Grocery Product Data From Walmart Usa
Author: FoodDataScrape

8. Extract Quick Commerce Data From Flipkart Minutes
Author: FoodDataScrape

9. Refurbished Laptop Scams And How To Safely Buy A Trusted Device
Author: Sujtha

10. Web Scraping Freshco Supermarket Product Data In Canada
Author: FoodDataScrape

11. How To Compare Two Lists In Excel​: A Definitive Guide For Data Professionals
Author: blackjack

12. Monthly Updated Uber Eats Menu Dataset For 500k+ Restaurants
Author: FoodDataScrape

13. Extract Mcdonalds Store Locations Data In Usa For Competitiveness
Author: FoodDataScrape

14. Scrape Spicy Food Trend Data In Usa 2025 For Competitive Advantage
Author: FoodDataScrape

15. Why Startups Should Invest In Custom Software Development Service
Author: Albert

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: