Working with Text in Excel

Working with Text in Excel

Format and Manage text using formulas such as TRIM, UPPER, LEFT, RIGHT, LEN, FIND, SUBSTITUTE, & TEXTJOIN

What will you learn in this course?

In this course, you will learn how to format text using formulas, find sequences or patterns, extract or replace parts of a text, join them and much more. Additionally, you will learn how to use Flash Fill to perform simple operations quickly without writing formulas.

An icon showing the number 1

Clean-up data

Cleaning up data can be a laborious and time-consuming process. Sorting through rows of data to make sure everything is in the right format can be an overwhelming task.

Text functions help you clean up data quickly and accurately.

You'll learn how to clean-up and format data using functions like UPPER, LOWER, PROPER and TRIM.
An icon showing the number 2

Extract or replace

Making errors while inputting data or updating it and trying to fix them can be a major source of frustration.

With Excel's text functions, you can quickly extract or replace text from cells.

You'll be able to do this using functions like FIND, SUBSTITUTE, LEN, LEFT, RIGHT and more.

An icon showing the number 3

Split or join

At times you need data that is merged, whereas on other occasions you need it split into granular details.

Excel provides multiple approaches to split and join data. We will cover multiple approaches to achieve the same result.

You will learn this through formulas like, LEN, LEFT, RIGHT, TEXTJOIN, CONCAT and more.

How will this course help you?

Most professionals focus more on Excel formulas and functionalities that help them analyze numbers. They don't pay sufficient attention to working with text in Excel.

However, a thorough understanding of text helps you do analysis, which otherwise is difficult to imagine. Through a structured approach to understanding the text functions in Excel, you can get much more out of the data at hand.

Working through data is tedious and overwhelming for many. If you don't see properly organized data, it makes the analysis even more difficult.

Most professionals work collaboratively and they receive data from multiple sources. Aggregating data and cleaning it up can be exhausting.

However, an understanding of how to use formulas to do this reduces your effort considerably. You'll be able to work through it faster without getting overwhelmed as you collate and sift through data.

Clean data also reduces errors in formulas and mis-interpretation of data.

Most people are comfortable working with numbers in Excel. However, they miss information available in text responses.

Instead of going through text manually looking for information or patterns, using formulas to extract information can be very convenient.

Text formulas are easy to understand. However, in most scenarios, you need to use a few of them together to extract, merge, or split data.

This can be overwhelming for many. In this course, we address this by teaching you simple techniques to break the formulas and get the information you are seeking in a few simple steps.

In addition, we also help you understand how to use Flash Fill, which eliminates the need to write formulas completely.

A young man wearing headphones and looking at a laptop with focus

What all does this course include?

You'll have access to all these benefits once you enroll in this course

An icon of a laptop

Short lessons for a quick understanding

An icon of a clipboard

Personalized feedback on assignment

An icon of a certificate

Course Certificate on approval of assignment

An icon of a badge

Earn a Skill Badge on approval of assignment

An icon of LinkedIn

Link to add certificate to your LinkedIn profile

An icon of a calendar

Invitations to upcoming webinars

An icon of chat sign

Discussion forum for clarifying doubts

An icon of downloading a file

Downloadable worksheets for practice

Course Curriculum

Get access to the course

Excel offers extremely useful functions for working with text. However, working with text may not be as intuitive as working with numbers.

Therefore, a thorough understanding of text functions can help you perform functions like format text, find an occurrence of characters, extract or replace parts of a text and much more.

This course teaches you how to work with the text functions. In addition, it also shows methods where you can cut through the complexity involved in working with the text functions.

Enroll to master working with text effortlessly.

Thumbnail for the course Working with Text in Excel showing a girl with glasses sitting with a laptop

Working with Text in Excel

Format and Manage text using formulas such as TRIM, UPPER, LEFT, RIGHT, LEN, FIND, SUBSTITUTE, & TEXTJOIN


  • Lifetime access
  • Workbook to practice along
  • Support available through discussion forums
  • Assignment & quiz included
  • Earn certificate & badge on assignment approval

Get access to the course

Excel offers extremely useful functions for working with text. However, working with text may not be as intuitive as working with numbers.

Therefore, a thorough understanding of text functions can help you perform functions like format text, find an occurrence of characters, extract or replace parts of a text and much more.

This course teaches you how to work with the text functions. In addition, it also shows methods where you can cut through the complexity involved in working with the text functions.

Enroll to master working with text effortlessly.

Thumbnail for the course Working with Text in Excel showing a girl with glasses sitting with a laptop

Working with Text in Excel

Format and Manage text using formulas such as TRIM, UPPER, LEFT, RIGHT, LEN, FIND, SUBSTITUTE, & TEXTJOIN


  • Lifetime access
  • Workbook to practice along
  • Support available through discussion forums
  • Assignment & quiz included
  • Earn certificate & badge on assignment approval

Music Credit: bensound.com