Excel problem with right and left function


I need the similar task.

I opened a XML file in excel

the problem is that it cannot process in any way the content of the cell.
It sees as part of the row (issuedate)
I wrote the formular LEFT, trying to obtain only the fist 10 characters of the cell.

The format of the row is TEXT.

Posted by Vladimir Tiltu (1) at 2025-07-21T10:10:35Z

Caught for

Contains Blacklisted Word - i need
Low Length
No Code Block
IntelliBL - -0.1
Low Rep