cancel
Showing results for 
Search instead for 
Did you mean: 

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

Luzern
Seasoned Pro
Posts: 3,381
Thanks: 351
Fixes: 3
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
Community Veteran
Posts: 38,460
Thanks: 1,030
Fixes: 62
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
Seasoned Pro
Posts: 3,381
Thanks: 351
Fixes: 3
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.
Community Veteran
Posts: 38,460
Thanks: 1,030
Fixes: 62
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
Seasoned Pro
Posts: 3,381
Thanks: 351
Fixes: 3
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.