Forum Discussion
values in number format but actualy not
mohammad10 wrote: ``how can i remove trailing space``
It is not a trailing space per se. But we can use LEFT(R7,7) to ignore the last character.
To convert the data, use =VALUE(LEFT(R7,7)). More generally, =VALUE(LEFT(R7,LEN(R7)-1)).
The last character seems to be the Unicode character 8236 (U+8236). You can see this in Excel with =UNICODE(RIGHT(R7,1)).
If your version of Excel does not support UNICODE (mine does not), in VBA, we write AscW(Right([R7],1)).
you are right
how can i remove trailing space because trim function dose not work
mohammad10 wrote: ``how can i remove trailing space``
It is not a trailing space per se. But we can use LEFT(R7,7) to ignore the last character.
To convert the data, use =VALUE(LEFT(R7,7)). More generally, =VALUE(LEFT(R7,LEN(R7)-1)).
The last character seems to be the Unicode character 8236 (U+8236). You can see this in Excel with =UNICODE(RIGHT(R7,1)).
If your version of Excel does not support UNICODE (mine does not), in VBA, we write AscW(Right([R7],1)).