Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Excel ...Exact function gives "False" result.... puzzle
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Excel ...Exact function gives "False" result.... p...
Excel ...Exact function gives "False" result.... puzzle
23-02-2010 1:06 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
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?
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
Re: Excel ...Exact function gives "False" result.... puzzle
23-02-2010 1:12 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
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
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
Re: Excel ...Exact function gives "False" result.... puzzle
23-02-2010 1:27 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
You were right! LEN function gives 14 and 9, but how does one remove trailing blanks , they being invisible?
No one has to agree with my opinion, but in the time I have left a miracle would be nice.
Re: Excel ...Exact function gives "False" result.... puzzle
23-02-2010 1:41 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
put the cursor at the end of the text and press backspace
unless you mean remove trailing blanks automatically then use this function
http://www.techonthenet.com/excel/formulas/trim.php
unless you mean remove trailing blanks automatically then use this function
http://www.techonthenet.com/excel/formulas/trim.php
Re: Excel ...Exact function gives "False" result.... puzzle
23-02-2010 1:50 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Very helpful indeed!
No one has to agree with my opinion, but in the time I have left a miracle would be nice.
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Excel ...Exact function gives "False" result.... p...