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.

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.

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.

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.

Better representation

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.

Insights from text

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.

Simplified working

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

Short lessons for a quick understanding

Personalized feedback on assignment

Course Certificate on approval of assignment

Earn a Skill Badge on approval of assignment

Link to add certificate to your LinkedIn profile

Invitations to upcoming webinars

Discussion forum for clarifying doubts

Downloadable worksheets for practice

Course Curriculum

Working with Text
11 Lessons
- Download Resource File
  Start
- Using CSV files with Excel and converting Text to Columns
  Start
- Cleaning up data using TRIM, UPPER, LOWER and PROPER
  Start
- Extracting Part of a Text or Phrase Using LEFT and RIGHT
  Start
- Extracting Part of a Text or Phrase Using FIND
  Start
- Extracting Part of a Text or Phrase Using MID
  Start
- Finding the Length of a Text or a Phrase
  Start
- Flash Fill: Getting things done without writing formulas
  Start
- Replacing Existing Text with New Text
  Start
- Splitting Text based on Spaces and other Characters
  Start
- Joining Multiple Elements of Text Together
  Start
Wrap-up
3 Lessons
- Quiz - Working with Text
  Start
- Final Words
  Start
- Assignment
  Start

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.