Spreadsheet formula right() does not work

Hi,
PFA the screenshot.
What is the problem, anything wrong I am doing, why it is not working?

I want the last 10 digits of the phone number using this.
It was working earlier, but now it is giving this kind of result.

1735972897217.png
 
Top