Excel
Extract and split tag strings, convert units and explore common Excel functions.
Excel Text Extract Helper
Suggest fixed-position or delimiter-based Excel formulas from source text and the substring you want to extract.
Open calculatorString Split Helper
Preview text split by a literal delimiter, with TEXTSPLIT for Microsoft 365 and guidance for older Excel versions.
Open calculatorUnit Conversion Formula Helper
Copy arithmetic or Excel CONVERT formulas that convert the value in cell A1 to another engineering unit.
Open calculatorCommon Excel Formula Examples
Explore common text functions using a fixed pipe-tag sample, with each formula and its expected result.
Open calculatorWhat this section covers
Build the formulas needed to handle patterned strings such as pipe tags, drawing numbers and material codes in Excel, for example extracting the area code from a tag like /P-PD2C-PIPE-BP-033 or splitting it on a delimiter, matched to your Excel version.
Microsoft 365's TEXTSPLIT, TEXTBEFORE and TEXTAFTER are not available in Excel 2016 or 2019, so older versions get MID, FIND, LEFT and RIGHT combinations or the Text to Columns feature instead.
Which tool should I use?
- Excel Text Extract Helper — Get a formula that extracts part of a tag
- String Split Helper — Split a string into several cells on a delimiter
- Unit Conversion Formula Helper — Put a unit conversion such as mm to inch or kg to lb into a cell
- Common Excel Formula Examples — See what MID, FIND, SUBSTITUTE and other text functions return on an example
Common mistakes
- Confusing FIND and SEARCH: FIND is case-sensitive and SEARCH is not.
- Using Microsoft 365-only functions in a file opened in Excel 2019: other users see #NAME? errors.
- Losing the leading zero of number-like text such as 033: keep the result as text or format it with TEXT.