I started noticing that the search within Excel only searches within the
first 1024 characters within a cell. It's a wicked bug and sort of
non-intuitive because if it will let you put more than 1024 characters in a
cell it should be able to come back later and find (via the search) any
character in the cell. When you search a spreadsheet for something and it
comes back and says quot;not foundquot; you really believe it's not there, when in
fact it might be there in some cell, just past the first 1024 characters
within the cell.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.
www.microsoft.com/office/comm...lic.excel.misc
maybe try a search function?
quot;frank479quot; wrote:
gt; I started noticing that the search within Excel only searches within the
gt; first 1024 characters within a cell. It's a wicked bug and sort of
gt; non-intuitive because if it will let you put more than 1024 characters in a
gt; cell it should be able to come back later and find (via the search) any
gt; character in the cell. When you search a spreadsheet for something and it
gt; comes back and says quot;not foundquot; you really believe it's not there, when in
gt; fact it might be there in some cell, just past the first 1024 characters
gt; within the cell.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc
- Sep 29 Fri 2006 20:09
Anyone notice excel search within cell limited to first 1024 chars
close
全站熱搜
留言列表
發表留言