Course Content

  • Formulas With Solution(3)

Course Content


Within an Excel spreadsheet, the TEXT Function is used to transform integers to text. The function essentially converts a numeric number to a text string. TEXT is available in all Excel versions.

A text string, usually referred to as a string or just text, is a collection of characters used as data in a spreadsheet software. Words make up the majority of text strings, although they can also include letters, numbers, special characters, the dash symbol, and the number sign.

The LEFT function in Excel can be used to extract the leftmost characters from a string. Add the FIND function to get a substring (of any length) before the dash. The FIND function determines the position of the dash. To get the right amount of leftmost characters, subtract 1 from this result.

String functions in Excel can be used to extract specific characters from a string. You just learned how to use Excel string functions in a variety of situations. To get your desired characters within a string, you can utilise any of the notions above, or a combination of the strategies described.

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