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

I have added an image and the link of the samplefile below

Hope for your response

Thank you

https://docs.google.com/spreadsheets/d/1Q5_5Uurc44ldWcopN4fE1hNA_9gdIweB/edit?usp=sharing&ouid=112310544159929632856&rtpof=true&sd=true