need help in Trim

[sksanjeev786]

Hi Team

I have written the Trim function in both the cell still getting false

book1
	H	I	J	K	L	M
22	AFAM W2TF v1 15s		AFAM W2TF v1 15s			FALSE
Sheet2

Cell Formulas
Range	Formula
M22	M22	=TRIM(H22)=TRIM(J22)

 

[JEC]

Works fine here, maybe you have non breaking spaces in that string --> char(160)

 

[HighAndWilder]

Hi Team

I have written the Trim function in both the cell still getting false

book1
	H	I	J	K	L	M
22	AFAM W2TF v1 15s		AFAM W2TF v1 15s			FALSE
Sheet2

Cell Formulas
Range	Formula
M22	M22	=TRIM(H22)=TRIM(J22)

I pasted this into a blank sheet and it works fine.

 

[sksanjeev786]

Works fine here, maybe you have non breaking spaces in that string --> char(160)

Yes! this is only 1 extra space so I have written the Trim so technically it should work.

i just removed 1 space from my file then it came True... so for extra space, we usually use the Trim function...

and yes when I copied this in another file I got Truee but on my data file so how to rectify this... with in my data file.

 

[JEC]

Yes but the Trim function will not remove "non-breaking spaces"

A space is char(32)
Non breaking space is char(160)

so if it machtes with this formula, it is present

=search(char(160),H22)

 

[sksanjeev786]

Yes but the Trim function will not remove "non-breaking spaces"

A space is char(32)
Non breaking space is char(160)

so if it machtes with this formula, it is present

=search(char(160),H22)

but i am not able to perform the True condition for both data if it same

 

[Alex Blakenburg]

The function JEC gave you is just meant to determine if character code 160 is the issue, use the formula on both H22 & J22 and show us what it returns.
Aternatively try:

=TRIM(SUBSTITUTE(H22,CHAR(160),""))=TRIM(SUBSTITUTE(J22,CHAR(160),""))

 

[felixstraube]

Can you share the file or a sample where you get the error, so we can have a look?
Upload to a cloud storage and share the link here