EngiCalcLab
EXCEL / String Split Helper

String Split Helper

Preview text split by a literal delimiter, with TEXTSPLIT for Microsoft 365 and guidance for older Excel versions.

Inputs

Updates as you type

The source text is assumed to be in A1. The first match is used; check the formula on other rows too. Regional settings may require semicolons instead of commas.

Results

Split items

5
/PPD2CPIPEBP033

TEXTSPLIT · Microsoft 365

=TEXTSPLIT(A1,"-")

Overview

Preview text split by a literal delimiter, with TEXTSPLIT for Microsoft 365 and guidance for older Excel versions.

Formula 

Microsoft 365: =TEXTSPLIT(A1,"-")
Excel 2016/2019: Data → Text to Columns

Example

Splitting /P-PD2C-PIPE-BP-033 on a hyphen gives five items: /P, PD2C, PIPE, BP and 033.

How to use

  1. Check the units, enter the required values and select the available calculation options.
  2. Results update immediately. Correct any highlighted input before using the result.
  3. Choose display precision, copy the result or share the current inputs. Reset restores the example values.

Engineering notes

  • Delimiters are literal text, not regular expressions. Consecutive delimiters can produce empty items.
  • For older Excel's single-character delimiter workflow, replace multi-character separators first. Quotes in generated formulas are escaped for Excel.

Frequently asked questions FAQ

How can I keep the leading zeros in 033?

In Text to Columns, set the relevant column's data format to Text. Converting a tag to a number removes its leading zeros.

Does display precision change the calculation?

No. Rounding is applied only to displayed results, not intermediate calculations. Small nonzero values use scientific notation. Consider the precision of the original measurements when interpreting results.

KEEP WORKING

Related tools

Excel

Excel Text Extract Helper

Suggest fixed-position or delimiter-based Excel formulas from source text and the substring you want to extract.

Open calculator
Excel

Unit Conversion Formula Helper

Copy arithmetic or Excel CONVERT formulas that convert the value in cell A1 to another engineering unit.

Open calculator
Excel

Common Excel Formula Examples

Explore common text functions using a fixed pipe-tag sample, with each formula and its expected result.

Open calculator