Split a Stock High and Low Range in Excel Using Text to Columns
Question details
Separate a 52-week stock range in one cell into individual high and low values.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains stock ranges such as "$100.00 / $50.00", and the user wants each value in a separate cell.
- Observed behavior
- The high and low values are combined in one cell, separated by a slash.
Check that the ranges consistently use a slash between the high and low values. Make sure the destination column and the column to its right are empty, because Text to Columns can overwrite existing data.
Split the stock range with Excel Text to Columns
Use the slash as a delimiter to place the high and low values in separate columns.
Select the cells containing the stock ranges, then open Data > Text to Columns.
Select Delimited and click Next. Clear any unwanted delimiters, select Other, and enter /.
Click Next, choose an empty destination cell, and check the preview to confirm that the range is split into two columns.
Click Finish. If the results are text with extra spaces, use a formula such as =TRIM(A1) in another cell. Apply Home > Number > Currency to values Excel recognizes as numbers.

Separate stock high and low values in WPS Spreadsheets
Use WPS Spreadsheets' Text to Columns tool to split a slash-separated stock range into two cells, then format numeric results as currency.
- 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select your workbook.
- 2. Select the ranges: Select the cells containing the stock ranges, then choose Data > Text to Columns.
- 3. Set the delimiter: Choose Delimited, select Other, and enter / as the delimiter. Clear any unwanted delimiter selections.
- 4. Complete the split: Choose an empty destination, review the preview, and click Finish. Use the Home tab's number format controls to format numeric results as currency.

Frequently Asked Questions
Which value will appear in the first column?
Text to Columns preserves the original order. For "$100.00 / $50.00", the high value appears first and the low value appears second.
How do I remove spaces around the split values?
If a split value is text, enter =TRIM(A1) in another cell, replacing A1 with the cell containing the value. Copy the formula down as needed.
Why can't I calculate with a split value?
The value may be stored as text, particularly if Excel did not recognize its currency symbol or decimal separator. Check your regional settings and convert the value to a number before calculating.
Will Text to Columns overwrite existing cells?
It can overwrite cells in the output range. In the wizard, select an empty destination with room for both resulting columns before clicking Finish.




