What Difference Between "A2" Cell Vs "A3" Cell, A2 and A3 Same, EXACT formula apply, but not come the "True"

[sivaprakasam]

Hi I am using the Excel 2013

What Difference Between "A2" Cell Vs "A3" Cell, but cells are the same as the A2 and A3, the "EXACT" formula applied, but the formula result did not come the "True". we cannot identify.

 

[AliGW]

The spaces between the number and KM are different types of spaces.

The first contains CHAR(32) - a regular space.
The second contains CHAR(160) - a non-breaking space.

 

[GraH - Guido]

Good catch, Ali.

 

[sivaprakasam]

Tnq so much for your kind reply..

i checked based on your reply, we split after 207 number, hereafter we applied the formula =UNICODE()

 

[rahulshewale1]

Hi @sivaprakasam ,


Visit Below Link for More information.
https://www.myonlinetraininghub.com/excel-trim-function-removes-spaces-from-text


Regard
Rahul Shewale