Why does search (ctrl-F) in Excel not work?re-format date insert by “CTRL ;” in excelWhy does Find in...
How does electrical safety system work on ISS?
C++ copy constructor called at return
Why do Radio Buttons not fill the entire outer circle?
Why can't the Brexit deadlock in the UK parliament be solved with a plurality vote?
How do you make your own symbol when Detexify fails?
Do we have to expect a queue for the shuttle from Watford Junction to Harry Potter Studio?
Why do ¬, ∀ and ∃ have the same precedence?
What is going on with gets(stdin) on the site coderbyte?
Shouldn’t conservatives embrace universal basic income?
What kind of floor tile is this?
Does the reader need to like the PoV character?
Why do some congregations only make noise at certain occasions of Haman?
Delete multiple columns using awk or sed
Why does the Sun have different day lengths, but not the gas giants?
Why should universal income be universal?
I found an audio circuit and I built it just fine, but I find it a bit too quiet. How do I amplify the output so that it is a bit louder?
Why is the "ls" command showing permissions of files in a FAT32 partition?
Is this toilet slogan correct usage of the English language?
Why is so much work done on numerical verification of the Riemann Hypothesis?
It grows, but water kills it
Does the Linux kernel need a file system to run?
Mimic lecturing on blackboard, facing audience
Is there a nicer/politer/more positive alternative for "negates"?
Stack Interview Code methods made from class Node and Smart Pointers
Why does search (ctrl-F) in Excel not work?
re-format date insert by “CTRL ;” in excelWhy does Find in Excel give unexpected results?Why can't I find/search some files in Windows 8?Outlook exact search not working?MS Excel: MIN and FIND/SEARCHExcel search for ~* or ~? sequenceExcel shortcut equivalent of double clicking fill handle (not ctrl + D)Excel Filter for the whole row content or display search result as rowsSearch for partial character string in ExcelKeyboard shortcut Ctrl+S does not work in Microsoft Excel 2016
Searching for a string in Excel (via ctrl-F) comes up with "We could't find what your looking for". The below screenshot tells the whole story.
Why is this?
microsoft-excel search
asked Jun 28 '18 at 0:14
pr1268pr1268
1063
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
|
show 2 more comments
Searching for a string in Excel (via ctrl-F) comes up with "We could't find what your looking for". The below screenshot tells the whole story.
Why is this?
microsoft-excel search
asked Jun 28 '18 at 0:14
pr1268pr1268
1063
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
What is the format Preview*?
– Mark Fitzgerald
Jun 28 '18 at 1:08
@MarkFitzgerald I don't know - I was playing around with the "Format" drop-down menu to see if any pre-defined format would narrow the search. No dice.
– pr1268
Jun 28 '18 at 2:06
1
I can't count how many times I got this problem, probably some non-visible character is still there
– phuclv
Jun 28 '18 at 2:12
I believe there is a funky character in there; problem is I'm at work on a Windows workstation and I can't just copy-and-paste the cell's contents into a shell andod -cit. Sigh... (Yes, I'm a hardcore Linux hacker at home. And proud of it!)
– pr1268
Jun 28 '18 at 2:57
And besides, I'm typing regular ASCII text in the search field, so even knowing what the "funky character(s)" is/are wouldn't help me. (again) Sigh...
– pr1268
Jun 28 '18 at 3:04
|
show 2 more comments
Searching for a string in Excel (via ctrl-F) comes up with "We could't find what your looking for". The below screenshot tells the whole story.
Why is this?
microsoft-excel search
asked Jun 28 '18 at 0:14
pr1268pr1268
1063
Searching for a string in Excel (via ctrl-F) comes up with "We could't find what your looking for". The below screenshot tells the whole story.
Why is this?
microsoft-excel search
microsoft-excel search
asked Jun 28 '18 at 0:14
pr1268pr1268
1063
asked Jun 28 '18 at 0:14
pr1268pr1268
1063
asked Jun 28 '18 at 0:14
pr1268pr1268
1063
asked Jun 28 '18 at 0:14
pr1268pr1268
1063
asked Jun 28 '18 at 0:14
pr1268pr1268
1063
1063
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
What is the format Preview*?
– Mark Fitzgerald
Jun 28 '18 at 1:08
@MarkFitzgerald I don't know - I was playing around with the "Format" drop-down menu to see if any pre-defined format would narrow the search. No dice.
– pr1268
Jun 28 '18 at 2:06
1
I can't count how many times I got this problem, probably some non-visible character is still there
– phuclv
Jun 28 '18 at 2:12
I believe there is a funky character in there; problem is I'm at work on a Windows workstation and I can't just copy-and-paste the cell's contents into a shell andod -cit. Sigh... (Yes, I'm a hardcore Linux hacker at home. And proud of it!)
– pr1268
Jun 28 '18 at 2:57
And besides, I'm typing regular ASCII text in the search field, so even knowing what the "funky character(s)" is/are wouldn't help me. (again) Sigh...
– pr1268
Jun 28 '18 at 3:04
|
show 2 more comments
1
What is the format Preview*?
– Mark Fitzgerald
Jun 28 '18 at 1:08
@MarkFitzgerald I don't know - I was playing around with the "Format" drop-down menu to see if any pre-defined format would narrow the search. No dice.
– pr1268
Jun 28 '18 at 2:06
1
I can't count how many times I got this problem, probably some non-visible character is still there
– phuclv
Jun 28 '18 at 2:12
I believe there is a funky character in there; problem is I'm at work on a Windows workstation and I can't just copy-and-paste the cell's contents into a shell andod -cit. Sigh... (Yes, I'm a hardcore Linux hacker at home. And proud of it!)
– pr1268
Jun 28 '18 at 2:57
And besides, I'm typing regular ASCII text in the search field, so even knowing what the "funky character(s)" is/are wouldn't help me. (again) Sigh...
– pr1268
Jun 28 '18 at 3:04
1
1
What is the format Preview*?
– Mark Fitzgerald
Jun 28 '18 at 1:08
What is the format Preview*?
– Mark Fitzgerald
Jun 28 '18 at 1:08
@MarkFitzgerald I don't know - I was playing around with the "Format" drop-down menu to see if any pre-defined format would narrow the search. No dice.
– pr1268
Jun 28 '18 at 2:06
@MarkFitzgerald I don't know - I was playing around with the "Format" drop-down menu to see if any pre-defined format would narrow the search. No dice.
– pr1268
Jun 28 '18 at 2:06
1
1
I can't count how many times I got this problem, probably some non-visible character is still there
– phuclv
Jun 28 '18 at 2:12
I can't count how many times I got this problem, probably some non-visible character is still there
– phuclv
Jun 28 '18 at 2:12
I believe there is a funky character in there; problem is I'm at work on a Windows workstation and I can't just copy-and-paste the cell's contents into a shell and
od -c it. Sigh... (Yes, I'm a hardcore Linux hacker at home. And proud of it!)– pr1268
Jun 28 '18 at 2:57
I believe there is a funky character in there; problem is I'm at work on a Windows workstation and I can't just copy-and-paste the cell's contents into a shell and
od -c it. Sigh... (Yes, I'm a hardcore Linux hacker at home. And proud of it!)– pr1268
Jun 28 '18 at 2:57
And besides, I'm typing regular ASCII text in the search field, so even knowing what the "funky character(s)" is/are wouldn't help me. (again) Sigh...
– pr1268
Jun 28 '18 at 3:04
And besides, I'm typing regular ASCII text in the search field, so even knowing what the "funky character(s)" is/are wouldn't help me. (again) Sigh...
– pr1268
Jun 28 '18 at 3:04
|
show 2 more comments
1 Answer
1
active
oldest
votes
The "funky character" theory is confirmed.
The text I was searching for had a plain space in it, but the contents of the cell I circled in red (in the image) has octal characters 302 240 which, according to Unix Stack Exchange is a "non-breaking space".
So, it looks like I'm screwed with plain text searches on this daily spreadsheet which usually contains 350 or so rows. Sigh... (for the third time)
answered Jun 28 '18 at 9:04
pr1268pr1268
1063
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1334808%2fwhy-does-search-ctrl-f-in-excel-not-work%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The "funky character" theory is confirmed.
The text I was searching for had a plain space in it, but the contents of the cell I circled in red (in the image) has octal characters 302 240 which, according to Unix Stack Exchange is a "non-breaking space".
So, it looks like I'm screwed with plain text searches on this daily spreadsheet which usually contains 350 or so rows. Sigh... (for the third time)
answered Jun 28 '18 at 9:04
pr1268pr1268
1063
add a comment |
The "funky character" theory is confirmed.
The text I was searching for had a plain space in it, but the contents of the cell I circled in red (in the image) has octal characters 302 240 which, according to Unix Stack Exchange is a "non-breaking space".
So, it looks like I'm screwed with plain text searches on this daily spreadsheet which usually contains 350 or so rows. Sigh... (for the third time)
answered Jun 28 '18 at 9:04
pr1268pr1268
1063
add a comment |
The "funky character" theory is confirmed.
The text I was searching for had a plain space in it, but the contents of the cell I circled in red (in the image) has octal characters 302 240 which, according to Unix Stack Exchange is a "non-breaking space".
So, it looks like I'm screwed with plain text searches on this daily spreadsheet which usually contains 350 or so rows. Sigh... (for the third time)
answered Jun 28 '18 at 9:04
pr1268pr1268
1063
The "funky character" theory is confirmed.
The text I was searching for had a plain space in it, but the contents of the cell I circled in red (in the image) has octal characters 302 240 which, according to Unix Stack Exchange is a "non-breaking space".
So, it looks like I'm screwed with plain text searches on this daily spreadsheet which usually contains 350 or so rows. Sigh... (for the third time)
answered Jun 28 '18 at 9:04
pr1268pr1268
1063
answered Jun 28 '18 at 9:04
pr1268pr1268
1063
answered Jun 28 '18 at 9:04
pr1268pr1268
1063
answered Jun 28 '18 at 9:04
pr1268pr1268
1063
1063
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1334808%2fwhy-does-search-ctrl-f-in-excel-not-work%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
What is the format Preview*?
– Mark Fitzgerald
Jun 28 '18 at 1:08
@MarkFitzgerald I don't know - I was playing around with the "Format" drop-down menu to see if any pre-defined format would narrow the search. No dice.
– pr1268
Jun 28 '18 at 2:06
1
I can't count how many times I got this problem, probably some non-visible character is still there
– phuclv
Jun 28 '18 at 2:12
I believe there is a funky character in there; problem is I'm at work on a Windows workstation and I can't just copy-and-paste the cell's contents into a shell and
od -cit. Sigh... (Yes, I'm a hardcore Linux hacker at home. And proud of it!)– pr1268
Jun 28 '18 at 2:57
And besides, I'm typing regular ASCII text in the search field, so even knowing what the "funky character(s)" is/are wouldn't help me. (again) Sigh...
– pr1268
Jun 28 '18 at 3:04