In this formula, "|" is the vertical glyph character (enclosed in double quotes) often accessed by pressing Shift or Fn at ...

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.