Data Import & Export

Split a Stock High and Low Range in Excel Using Text to Columns

Elise WilliamsElise Williams Nov 22, 2026 868 views

Question details

Separate a 52-week stock range in one cell into individual high and low values.

Split a Stock High and Low Range in Excel Using Text to Columns
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the ranges

Select the cells containing the stock ranges, then open Data > Text to Columns.

2
Choose a delimiter

Select Delimited and click Next. Clear any unwanted delimiters, select Other, and enter /.

3
Choose the destination

Click Next, choose an empty destination cell, and check the preview to confirm that the range is split into two columns.

4
Finish and clean up

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.

Split the stock range with Excel Text to Columns
Check the value format: Excel's recognition of currency symbols and decimal separators depends on regional settings. If a result remains text, convert it to a number before applying currency formatting or using it in calculations.
Split stock ranges in WPS Spreadsheets

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. 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select your workbook.
  2. 2. Select the ranges: Select the cells containing the stock ranges, then choose Data > Text to Columns.
  3. 3. Set the delimiter: Choose Delimited, select Other, and enter / as the delimiter. Clear any unwanted delimiter selections.
  4. 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.
Split high and low stock values using a slash delimiterOpen and edit Microsoft Excel XLS and XLSX filesUse familiar spreadsheet tools in a free office suite
microsoft office alternative - wps office

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.