Function Problems

How to Extract Numbers Before and After a Slash in Excel

Adam DavisAdam Davis Nov 2, 2026 872 views

Question details

The user needs to split varying-length text strings containing a slash (such as 123/45) into separate numerical values.

How to Extract Numbers Before and After a Slash in Excel
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.
Before you start

Ensure you have at least two blank columns next to your target data to accommodate the extracted numbers without overwriting any existing spreadsheet information.

Solution 1Recommended

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.

1
Select the first adjacent cell

Click on the first empty cell next to your data (e.g., D2) to extract the number located before the slash.

2
Input the LEFT formula

Enter the formula =--LEFT(C2,FIND("/",C2)-1) and press Enter. This isolates all digits appearing before the slash character.

3
Select the second adjacent cell

Click on the next empty cell to the right (e.g., E2) to extract the number located after the slash.

4
Input the MID formula

Enter the formula =--MID(C2,FIND("/",C2)+1,LEN(C2)) and press Enter. This extracts the remaining characters to the right of the slash.

5
Apply formulas to the entire column

Select both formula cells (D2 and E2) and drag the fill handle down to apply the logic to the rest of your data set.

Use Dynamic Formulas to Extract Numbers Based on Slash Position
Number Formatting: By using the double negative (--), you ensure the extracted data behaves like numbers, allowing you to use them in subsequent math formulas or charts.
Simplify Data Management with WPS Office

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing the combined data strings.
  2. 2. Access the Text to Columns tool: Select the data column, switch to the 'Data' tab, and click 'Text to Columns'.
  3. 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.
100% compatibility with Microsoft Excel formulas like LEFT, MID, and FIND.Intuitive Text to Columns tool to separate text in seconds.Free and lightweight office suite for Windows, Mac, and mobile.Familiar user interface requiring zero learning curve.
microsoft office alternative - wps office

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.