Forum Discussion

littlevillage's avatar
littlevillage
Iron Contributor
Jul 30, 2022
Solved

Left function not working correctly

Hi, I have an issue with left function, It returns the whole result the same first row. But when I save the file, it returns correctly results Office version: 2021 The Platform OS: windows 10 pro ...
  • Riny_van_Eekelen's avatar
    Jul 30, 2022

    littlevillage Make sure Calculation options are set to automatic. You'll find the button on the Formulas ribbon.

     

Resources