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

If Excel is not highlighting cells in the formula, ... Turn off ‘Disable hardware graphics acceleration’ in Excel options. A few users have tried their luck on this setting and it worked.