How to Extract SDX65 or SDX70 from a Cell in WPS Office Spreadsheets
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.

- 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.
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.
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.
Click cell B2, where the first formula result should appear.
Type =IF(ISNUMBER(SEARCH("SDX65",A2)),"SDX65",IF(ISNUMBER(SEARCH("SDX70",A2)),"SDX70","")) into the formula bar.
Press Enter, then drag the fill handle from cell B2 down through the remaining rows.

Use FIND instead of SEARCH for case-sensitive matching
Use this when the formula should only match exact uppercase SDX65 or SDX70 and ignore lowercase variations.
Use IFERROR, MID, and SEARCH to extract any SDX?? code
Use this when your text always contains a five-character code beginning with SDX and you want a shorter formula.
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. Open the workbook: Launch WPS Office Spreadsheets and open the .xlsx file that contains the text in column A.
- 2. Select the output cell: Click cell B2, the first cell where you want the extracted SDX65 or SDX70 value.
- 3. Enter the formula: Type =IF(ISNUMBER(SEARCH("SDX65",A2)),"SDX65",IF(ISNUMBER(SEARCH("SDX70",A2)),"SDX70","")) into the formula bar.
- 4. Fill the results down the column: Press Enter and drag the fill handle from cell B2 through the remaining rows.

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.




