EngiCalcLab
EXCEL / Common Excel Formula Examples

Common Excel Formula Examples

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

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.

A1 = /P-PD2C-PIPE-BP-033

Results

Expected result

PD2C

Excel 2016 / 2019 / Microsoft 365

=MID(A1,4,4)

Overview

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

Formula 

A1 = /P-PD2C-PIPE-BP-033
MID · LEFT · RIGHT · FIND · SEARCH
LEN · SUBSTITUTE
TEXTBEFORE · TEXTAFTER (Microsoft 365)

Example

=FIND("PD2C",A1) returns 4. =SEARCH("pd2c",A1) also returns 4, but ignores case. =LEN(A1) returns 19.

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

  • FIND is case-sensitive. SEARCH is case-insensitive and supports wildcards.
  • FIND/SEARCH return #VALUE! in Excel when no match exists. Add IFERROR when your worksheet requires a fallback.

Frequently asked questions FAQ

Does this read or modify my workbook?

No. It displays sample formulas in your browser and does not upload or change any Excel file.

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

String Split Helper

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

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