Function Problems

How to Extract SDX65 or SDX70 from a Cell in WPS Office Spreadsheets

Adam DavisAdam Davis Nov 13, 2026 869 views

Question details

The user needs a formula to populate column B with SDX65 or SDX70 when the text in column A contains a matching code.

How to Extract SDX65 or SDX70 from a Cell in WPS Office Spreadsheets
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
The user is working with a spreadsheet where column A contains descriptive text and wants to automatically return the matching SDX code in column B.
Observed behavior
Column B should display SDX65, SDX70, or a blank value depending on the text found in column A.
Before you start

Open the WPS Office spreadsheet containing the source text in column A and confirm that column B is available for formula results. If you need case-sensitive matching, plan to use FIND instead of SEARCH.

Solution 1Recommended

Use IF, ISNUMBER, and SEARCH to return SDX65 or SDX70

Best when you want to match SDX65 or SDX70 anywhere in a cell and return a blank when neither code exists.

This formula checks whether the cell contains SDX65 first. If it does not, it checks for SDX70. If neither code is present, the formula returns an empty string.

1
Select the first result cell

Click cell B2, where the first formula result should appear.

2
Enter the IF and SEARCH formula

Type =IF(ISNUMBER(SEARCH("SDX65",A2)),"SDX65",IF(ISNUMBER(SEARCH("SDX70",A2)),"SDX70","")) into the formula bar.

3
Apply the formula to the rest of column B

Press Enter, then drag the fill handle from cell B2 down through the remaining rows.

Use IF, ISNUMBER, and SEARCH to return SDX65 or SDX70
Result: The formula returns SDX65, SDX70, or a blank value without changing the original text in column A.

Extract SDX65 or SDX70 in WPS Office Spreadsheets with an Excel-Compatible Formula

Open your workbook in WPS Office Spreadsheets and use the IF, ISNUMBER, and SEARCH formula to automatically fill column B with the correct code. WPS Office keeps the same formula behavior as Microsoft Excel, so your existing .xlsx files work without conversion.

  1. 1. Open the workbook: Launch WPS Office Spreadsheets and open the .xlsx file that contains the text in column A.
  2. 2. Select the output cell: Click cell B2, the first cell where you want the extracted SDX65 or SDX70 value.
  3. 3. Enter the formula: Type =IF(ISNUMBER(SEARCH("SDX65",A2)),"SDX65",IF(ISNUMBER(SEARCH("SDX70",A2)),"SDX70","")) into the formula bar.
  4. 4. Fill the results down the column: Press Enter and drag the fill handle from cell B2 through the remaining rows.
Free spreadsheet editor with Excel-compatible formulasOpens and saves .xlsx files without conversionFamiliar formula bar and fill handle workflowLightweight and suitable for quick text extraction tasks
QA img-9

Frequently Asked Questions

How do I make the formula return a blank when no SDX code is found?

Include the final empty string argument in the nested IF formula. For example, end the formula with "" so that WPS Spreadsheets returns a blank instead of FALSE or an error.

Can I extract SDX65 or SDX70 from text in WPS Office on Windows and Mac?

Yes. WPS Office Spreadsheets supports the same SEARCH, FIND, IF, ISNUMBER, MID, and IFERROR formulas on Windows, macOS, Linux, Android, and iOS.

What is the difference between SEARCH and FIND in this extraction formula?

SEARCH is case-insensitive and supports wildcard characters, while FIND is case-sensitive. Use FIND instead of SEARCH when you only want to match uppercase SDX65 or SDX70.

How can I extract any five-character code that starts with SDX?

Use =IFERROR(MID(A2,SEARCH("SDX??",A2),5),""). The ?? wildcard looks for any two characters after SDX and MID returns the five-character match.

Why does the formula show #NAME? in WPS Spreadsheets?

Check that all function names are spelled correctly and that double quotes are used around SDX65 and SDX70. If your spreadsheet uses a different locale, adjust the function names or argument separators as shown in WPS Office.