Function Problems

How to Remove Specific Text and Numbers from Excel Cells

Maira Mehtab Sep 21, 2026 870 views

Question details

The user needs to remove specific words and numeric values from Excel cells containing property and street names.

Product: Excel
Device & OS: not provided
Scenario: Cleaning up address or property data by stripping out unwanted specific text strings and numbers.
Observed behavior: Cells currently contain a mix of desired text alongside unwanted words and numeric characters that need to be eliminated to achieve clean data.

Before you start

Identify the exact words, characters, or number patterns you wish to remove to ensure you do not accidentally delete valid parts of your address or property data.

Solution 1Recommended

Use Find and Replace to Remove Specific Words

The quickest method to remove an exact word or phrase from multiple cells at once.

Select the target range

Highlight the cells containing the data you want to modify.

Open Find and Replace

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

Enter the text to remove

In the 'Find what' field, type the specific word you want to remove (e.g., 'Singapore'). Leave the 'Replace with' field completely blank.

Execute the replacement

Click the 'Replace All' button. Excel will remove all instances of the specified word from the selected cells.

Solution 2

Use the SUBSTITUTE Function in a Helper Column

Ideal if you want to keep your original data intact and generate the cleaned text in a new, adjacent column.

Solution 3

Apply a VBA Macro for Advanced Cleanup

Use this method if you need to systematically remove text, all numeric digits (0-9), and trim extra spaces simultaneously.

Clean Data Easily in WPS Spreadsheet

Effortlessly Clean and Format Data with WPS Spreadsheet

WPS Spreadsheet provides powerful data processing tools, including advanced Find and Replace, text functions, and full macro support, making it incredibly easy to clean unwanted text and numbers from your data.

1. Open your dataset in WPS: Launch WPS Spreadsheet and open the file containing your text and numbers.
2. Use quick tools to clean text: Press Ctrl+H to open Find and Replace for immediate removal of unwanted words.
3. Apply formulas for dynamic results: Use built-in functions like SUBSTITUTE to extract or remove specific characters while keeping original data safe.

Fully compatible with Microsoft Excel formulas like SUBSTITUTE and TRIMSupports advanced Find & Replace for quick data cleanup tasksSeamlessly handles VBA macros for complex data formatting and automation

microsoft office alternative - wps office

Frequently Asked Questions

Will the SUBSTITUTE function remove text regardless of case?

No, the SUBSTITUTE function is case-sensitive. It will only remove text that exactly matches the capitalization you specified in the formula. If you need a case-insensitive replacement, you can use Find and Replace, or nest the SUBSTITUTE function with UPPER or LOWER.

How do I remove extra spaces left after removing text?

When you remove a word from the middle of a sentence, it often leaves a double space. You can fix this by wrapping your original formula in the TRIM function, such as `=TRIM(SUBSTITUTE(B2, "Singapore", ""))`. This will automatically remove leading, trailing, and extra internal spaces.

Can I remove all numbers from a cell without using VBA?

Yes, but it requires nesting multiple SUBSTITUTE formulas to target digits 0 through 9 individually. Alternatively, you can use the Flash Fill feature (Ctrl+E) by manually typing the desired text without the numbers in the first adjacent cell, and letting the software automatically detect and apply the pattern to the rest of the column.

Excel & Data Problems