SOLVED

Left function not working correctly

Iron Contributor

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

small_village_0-1659143714203.png

 

https://docs.google.com/spreadsheets/d/1Q5_5Uurc44ldWcopN4fE1hNA_9gdIweB/edit?usp=sharing&ouid=11231... 

2 Replies
best response confirmed by littlevillage (Iron Contributor)
Solution

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

Riny_van_Eekelen_0-1659147536856.png

 

@Riny_van_Eekelen 

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

1 best response

Accepted Solutions
best response confirmed by littlevillage (Iron Contributor)
Solution

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

Riny_van_Eekelen_0-1659147536856.png

 

View solution in original post