Left function not working correctly

Frequent Contributor


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


2 Replies
best response confirmed by small_village (Frequent Contributor)

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




You have saved my time, you are a hero
Thank you so much