Jul 29 2022 06:16 PM
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
I have added an image and the link of the samplefile below
Hope for your response
Thank you
Jul 29 2022 07:19 PM
Solution@littlevillage Make sure Calculation options are set to automatic. You'll find the button on the Formulas ribbon.
Jul 29 2022 11:02 PM
You have saved my time, you are a hero
Thank you so much
Jul 29 2022 07:19 PM
Solution@littlevillage Make sure Calculation options are set to automatic. You'll find the button on the Formulas ribbon.