Function Problems

How to Remove One Specific Prefix While Keeping Another in Excel

Nimra Malik Sep 28, 2026 872 views

Question details

The user needs to remove a specific text prefix from a large dataset while leaving other prefixes unchanged.

How to Remove One Specific Prefix While Keeping Another in Excel

Product: Excel
Device & OS: not provided
Scenario: Cleaning up a large column of reference data that contains mixed prefixes, such as TEL-1000 and WAL-1067.
Observed behavior: The goal is to selectively remove a targeted prefix (e.g., TEL-) without affecting other prefixes (e.g., WAL-) or the numerical data following them.

Before you start

Identify the exact text of the prefix you want to remove (e.g., 'TEL-') and verify whether this text sequence might accidentally appear in the middle of other cell values before doing a bulk replacement.

Solution 1Recommended

Use Find and Replace to Remove the Specific Prefix

The quickest way to remove a specific text string from an entire column without affecting other cell contents is using the built-in Find and Replace feature.

This method is highly efficient for large datasets. By leaving the replacement field blank, Excel effectively deletes the targeted prefix while completely ignoring cells that contain different prefixes like 'WAL-'.

Select the target column

Click on the column letter (e.g., Column A) to highlight all the data containing the mixed prefixes.

Open Find and Replace

Press the keyboard shortcut Ctrl+H to open the Find and Replace dialog box.

Enter the specific prefix

In the 'Find what' field, type the exact prefix you want to remove, such as 'TEL-'.

Configure replacement settings

Leave the 'Replace with' field completely blank. Ensure that 'Match case' and 'Match entire cell contents' are disabled in the Options menu.

Execute the replacement

Click the 'Replace All' button. Excel will remove 'TEL-' from all applicable cells while preserving 'WAL-' and the rest of the data.

Use Find and Replace to Remove the Specific Prefix

Quick Cleanup: A confirmation popup will appear showing exactly how many replacements were made, allowing you to verify that the correct number of prefixes were removed.

Solution 2

Use an IF Formula for Dynamic Prefix Removal

If you want to keep your original data intact and generate the cleaned data in a new column, using an IF formula combined with text functions is the safest approach.

Efficient Data Cleaning with WPS Office

Remove Specific Prefixes Easily with WPS Spreadsheet

WPS Spreadsheet provides powerful data manipulation tools, including an advanced Find and Replace utility and full support for complex Excel formulas, making text cleanup tasks effortless.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing your mixed prefix data.
2. Highlight the data: Select the specific column that needs the prefix removed.
3. Launch Find and Replace: Press Ctrl+H to instantly bring up the Find and Replace dialog.
4. Input the target prefix: Type the prefix (e.g., 'TEL-') into 'Find what' and leave 'Replace with' empty.
5. Clean the data: Click 'Replace All' to strip the targeted prefix while perfectly preserving the other prefixes.

Fully compatible with Microsoft Excel formulas and file formatsFree, lightweight, and fast alternative to Microsoft OfficeAdvanced text manipulation tools for quick data cleanupIntuitive tabbed interface for managing multiple spreadsheets

microsoft office alternative - wps office

Frequently Asked Questions

Will Find and Replace remove the text if it appears in the middle of a cell?

Yes, a standard Find and Replace will remove the text string anywhere it appears in the cell. If your target prefix might appear in the middle of your data (e.g., '123-TEL-456'), it is safer to use the IF formula method, which only targets the beginning of the cell.

How do I remove the first 4 characters regardless of what they are?

If you want to uniformly strip the first four characters from all cells, you can use the REPLACE function. For example, enter =REPLACE(A1, 1, 4, "") in an adjacent column to replace the first 4 characters with nothing.

Can I extract the prefix into a separate column instead of deleting it?

Yes. You can use the 'Text to Columns' feature found in the Data tab. Select 'Delimited', choose the hyphen (-) as your delimiter, and Excel will separate the prefix and the numbers into two adjacent columns.

How can I remove multiple different prefixes at the same time?

You can either perform the Find and Replace operation sequentially for each prefix, or use nested SUBSTITUTE formulas, such as =SUBSTITUTE(SUBSTITUTE(A1, "TEL-", ""), "FAX-", ""), to remove multiple target strings simultaneously.

Excel & Data Problems