cancel
Showing results for 
Search instead for 
Did you mean: 

Excel ...Exact function gives "False" result.... puzzle

Luzern
Hero
Posts: 4,823
Thanks: 872
Fixes: 9
Registered: ‎31-07-2007

Excel ...Exact function gives "False" result.... puzzle

I tried to compare two text strings to see they are the same. They have the same cell format, font style, size, and colour, yet the result of comparison is "False",
Am I misunderstanding the "Exact" function?
No one has to agree with my opinion, but in the time I have left a miracle would be nice.
4 REPLIES 4
Oldjim
Resting Legend
Posts: 38,460
Thanks: 787
Fixes: 63
Registered: ‎15-06-2007

Re: Excel ...Exact function gives "False" result.... puzzle

You aren't.
I just did a quick check and adding a trailing blank to one of the text strings makes the answer false - might be worth checking
Luzern
Hero
Posts: 4,823
Thanks: 872
Fixes: 9
Registered: ‎31-07-2007

Re: Excel ...Exact function gives "False" result.... puzzle

You were right! Smiley LEN function gives 14 and 9, but how does one remove trailing blanks , they being invisible? Undecided
No one has to agree with my opinion, but in the time I have left a miracle would be nice.
Oldjim
Resting Legend
Posts: 38,460
Thanks: 787
Fixes: 63
Registered: ‎15-06-2007

Re: Excel ...Exact function gives "False" result.... puzzle

put the cursor at the end of the text and press backspace  Grin
unless you mean remove trailing blanks automatically then use this function
http://www.techonthenet.com/excel/formulas/trim.php
Luzern
Hero
Posts: 4,823
Thanks: 872
Fixes: 9
Registered: ‎31-07-2007

Re: Excel ...Exact function gives "False" result.... puzzle

Very helpful indeed! Smiley
No one has to agree with my opinion, but in the time I have left a miracle would be nice.