Course Content

  • Formulas

Course Content


VLOOKUP is an abbreviation for 'Vertical Lookup.' It's a function that tells Excel to look for a specific value in a column (the so-called'table array') in order to return a value from another column in the same row.

VLOOKUP will make the match if you use TEXT as the first argument. Yes, as stated in cell C7 below, it worked. We could also use our friend IFERROR, which we explored in a previous post, if we needed to construct a function that worked for both text and numbers.

You may now connect the names back together using a concatenation method. =B2&", "&A2" would be the formula. To join or concatenate, use the ampersand character. Double quotes must enclose literal characters like a comma and then a space.

To extract text off the right side of a text string, use the RIGHT function. Use the LEFT method to extract text from the text's left side, and the MID function to retrieve text from the text's middle. The LEN function returns the length of a string as a character count.

The LEN function in Excel can count the number of characters in a text string and can count letters, numbers, special characters, non-printable characters, and all spaces in a cell. The length of a supplied text string will be returned by this function.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere