LEN vs Characteristic count

[R2ah1ze1l]

I have a file that holds some data, I wanted to keep the characteristics in specified cells to less then a length of 18 characters total.
I tried using the round function, then the trunc function. When I use the len function it returns a value of 13. All things should be good right?
I seem to be getting an error on a sample of lines where it appears there is still greater than 18 characters. Does trunc only reduce the value on the surface?

FYI I performed the trunc function in an adjacent column, copied that data and re-pasted it in the original cells as 'values only'.
Any ideas are appreciated!

 

[R2ah1ze1l]

The location I am uploading to would prefer that it is submitted in text.
It eliminates the concern of the trailing values.

 

[Joe4]

The location I am uploading to would prefer that it is submitted in text.

Then the LEFT function without the "+0" on the end should suffice.