Excel Formula: How to Extract Text from a cell

Excel with its so many functions has given many choices to its users to use any method to fulfill their tasks and work efficiently. Now along with its data organizing, analyzing, and providing chart sheets. It also lets the user perform certain functions for their ease. And the extracting of character from a cell is a useful function and a basic one that every individual should at least know.

Individuals tend to make mistakes when they are inserting critical data or are trying to find or extract from a specific cell or the texts and characters in which they consist. And so excel is made it more convenient for its user to find and extract specific text or words with the usage of several methods.

Here in this article, you will be learning how to extract before or after a character from a cell using multiple methods.

How To Extract Before Text Using The Find Left Function

For extracting the text which is before the comma, we will be using the LEFT and Find function. 

FIND FUNCTION:

Firstly we will be finding the location of the comma by using the find function and then we will be deducting 1 to where the value which is returned to know the last name length.

The function which will be used is mentioned below:

Formula:

=FIND(,,B5)-1

Insert this function in B5.Press Enter Key.Drag down the formula to get instant values.

LEFT FUNCTION:

In this function the formula we are using is:

Formula:

=LEFT(B5,C5)

Put in this function in D5.Press Enter Key.Drag down the formula to get instant values.

So, you have learned the extraction of text from a cell by now.

Hence, you do understand now that combining both functions yields the formula.

Manage To Extract Text By Using LEFT And FIND Function:

In this method the function will be:

Formula:

=LEFT(B5,FIND(,,B5)-1)

Use this  function in C5.Press Enter Key.Drag down the formula to get instant values.

You now know the major function to easily perform this task and have your text extracted from the cell.

Manage To Extract After Text Using The LEFT And Find Functions:

Here we will be extracting after text in the given cell.

The formula which we are using here is mentioned below:

=RIGHT(B5,LEN(B5)-FIND(,,B5)-1)

Insert this given formula in cell C5.Press the Enter key.Drag down the formula to your desired cell for fulfilling your task.

Finally, you do know multiple methods to extract texts or characters from a specific cell by using these functions.

Did you learn about how to extract before and after characters or text from a cell in Excel Spreadsheets? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.

You can also download WPS Office to edit word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.