Where A1 contains text 2021-2022
=“Bank Balance Forward on Sept 1, “ & LEFT(A1,1,4) not working,
=LEFT(A1,1,4) however works.
In first case the formula appears visible as text in Cell,
in second case below, it generates Error 509
="Bank Ending Balance on Aug 31, " & RIGHT(A1,6,4)
Does the comma before the ending quote need to be escaped?
Sometimes LibreCalc changes quotes to backquotes (Smart quote?) but this does not seem to be case here.