Difference in look alike cells

hmm thats got me. Comparing letter for letter, the only 2 that match are the 1st character and the space...

	A	B	C	D	E	F	G	H	I	J
1	body		Len	1	2	3	4	5	6	7
2	?APE ME	FALSE	7	TRUE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE
3	???? ??		7	?	A	P	E		M	E

For a letter-by-letter comparison, I used...
=MID($A2,D$1,1)=MID($A3,D$1,1)

It is probably something glaringly simple, but I just cant see it - I will push this to the other experts.

Interesting...the copy almost comes through on the 1st instance, but errors on the 2nd 1???????

Pulling out each letter from both lines...

	A	B	C	D	E	F	G	H	I	J
1	body		Len	1	2	3	4	5	6	7
2	?APE ME	FALSE	7	TRUE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE
3	???? ??		7	?	A	P	E		M	E
4				?	?	?	?		?	?

CODE pulls out weird returns for the 2nd row...

	A	B	C	D	E	F	G	H	I	J
1	body		Len	1	2	3	4	5	6	7
2	?APE ME	FALSE	7	TRUE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE
3	???? ??		7	?	A	P	E		M	E
4				?	?	?	?		?	?
5
6			Code	63	65	80	69	32	77	69
7			Code	63	63	63	63	32	63	63

lower case A2: πape me
lower case A3: παρε με
Greek??

---

AscW(A2)= 928 65 80 69 32 77 69
AscW(A3)= 928 913 929 917 32 924 917

Hi All,

but in A2 only the first character is Greek

Maybe: "only the first character looks Greek"?


Just for information:

Like the other contributors here I did a character-by-character comparison and found that the only "equals" were the Pi and the space characters - so I looked at the Character Map.

Lo and behold, identical looking characters appear in the sets both of the Roman characters and also of the Greek characters.

One at a time, I copied the Greek characters A, P, E and M, E into the first cell (A2), and one by one the character comparisons appeared as equal.

Maybe the problem arose as a result of different keyboards being used to enter the data in each cell?

Hope this helps.

Regards,

Greg M

drgkt... you will not be able to open my file, but others will.

In A2, only the first character belongs to the UNICODE set for Greek/Coptic characters.

In A3, all of the characters are from the Greek Unicode set. That is why they are not the same.

So, Greg's right. Only the A3 text is truly Greek. A2 is Greenglish....

Thanks for the assist, guys

The joys of multiple standards.

Text Encoding
Date Format
Units of Measure
Currency
etc

Keeps us in work, though