How to Extract Numbers Before and After a Slash in Excel
Question details
The user needs to split varying-length text strings containing a slash (such as 123/45) into separate numerical values.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Organizing data entries like blood pressure readings that are combined into a single cell with a slash separator.
- Observed behavior
- The combined text strings must be dynamically separated into two distinct cells containing the numbers located before and after the slash character.
Ensure you have at least two blank columns next to your target data to accommodate the extracted numbers without overwriting any existing spreadsheet information.
Use Dynamic Formulas to Extract Numbers Based on Slash Position
Using a combination of FIND, LEFT, and MID functions ensures numbers are extracted accurately regardless of their varying digit lengths.
Because the digit lengths can vary (e.g., 120/80 vs 90/60), using fixed-length text functions is not reliable. Finding the exact position of the slash dynamically solves this issue.
Adding a double negative (--) before the text functions forces Excel to convert the extracted text strings back into usable numerical values.
Click on the first empty cell next to your data (e.g., D2) to extract the number located before the slash.
Enter the formula =--LEFT(C2,FIND("/",C2)-1) and press Enter. This isolates all digits appearing before the slash character.
Click on the next empty cell to the right (e.g., E2) to extract the number located after the slash.
Enter the formula =--MID(C2,FIND("/",C2)+1,LEN(C2)) and press Enter. This extracts the remaining characters to the right of the slash.
Select both formula cells (D2 and E2) and drag the fill handle down to apply the logic to the rest of your data set.

Split Data Using the Text to Columns Feature
The Text to Columns wizard allows you to quickly split data across multiple columns based on a specific delimiter without writing any formulas.
Easily Split and Manage Data with WPS Spreadsheet
WPS Spreadsheet provides powerful data handling tools, including an intuitive Text to Columns wizard and full support for advanced text formulas, making complex data cleaning tasks simple.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing the combined data strings.
- 2. Access the Text to Columns tool: Select the data column, switch to the 'Data' tab, and click 'Text to Columns'.
- 3. Apply the slash delimiter: Choose 'Delimited', type '/' into the custom delimiter box, select an empty destination cell, and click 'Finish' to split the data instantly.

Frequently Asked Questions
Why do the extracted numbers behave like text instead of numbers?
Text extraction functions like LEFT, RIGHT, and MID output text strings by default, even if the characters are digits. To convert the text back into a true number format, add a double negative (--) in front of the formula, or multiply the entire formula by 1.
What happens if there are multiple slashes in one cell?
If you use the Text to Columns feature, Excel will create a new column for every slash it finds. If you are using the FIND formula provided, it will only locate the first slash. Extracting numbers between multiple slashes requires more complex nested formulas or Power Query.
Can I use Flash Fill instead of formulas or Text to Columns?
Yes. In modern versions of Excel and WPS Spreadsheet, you can manually type the number before the slash into the adjacent cell, press Enter, and then press Ctrl+E to activate Flash Fill. The software will detect your pattern and auto-fill the remaining numbers.




