Open In App

How to Remove Text Before or After a Specific Character in Excel?

Improve
Improve
Like Article
Like
Save
Share
Report

Excel is powerful data visualization and data management tool. It is used to store, analyze, and create reports on large amounts of data. It is generally used by accounting professionals for the analysis of financial data but can be used by anyone to manage large data. Data is entered into the rows and columns. And then, formulas and functions can be used to turn data insights. Let’s see how to remove the text before and after a specific character or text string in Excel. 

Steps to Remove Text Before or After a Specific Character in Excel

For example, if you have the name and age of people in the data field separated by a comma(,), you may want to remove the age after the comma and only keep the name.

Data

After removing texts present after comma(,),

Removing-comma

We can do this task using find and replace in Excel.

Using find and replace

For this method, we will use the asterisk(*) wild character (It represents any number of characters). Suppose we have the following data in the excel sheet, and we want to delete the text before the comma(,).

Database

Step 1: Select the data and select the Home tab.

Selecting-home-tab

Step 2: Click on the find and select option.

Step 3: From the dropdown, select the ‘Replace’ option. The find and replace dialog box will appear on the screen.

Step 4: To find what field, enter ‘*,’ (Represents any character before,) and keep the replace field empty.

Find-and-replace-dialogue-box

Step 5: Select Replace All option

Output:

Output

Last Updated : 02 Jun, 2022
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads