KimHook99 1 Posted September 15, 2016 Share Posted September 15, 2016 I have a lot of notes with tips about excel formulae and want to be able to find and go back to specific notes. As you probably know, in Excel formulae start with an equals sign. So I tried searching for "=text(" which is a phrase or string I know for certain is in one note. Unfortunately, EN strips out the symbols and finds every note which has the word 'text' in it, of which there are far too many to manually look through. Adding ? for any one character or * for any number of characters also doesn't work. Does anyone have an idea for searching the beginning of an excel formula? Link to comment
Level 5* CalS 5,284 Posted September 15, 2016 Level 5* Share Posted September 15, 2016 About the only special character that is searchable is the underscore, _. You could search for whatever follows the equals sign or whatever function you are interested in reviewing. Different way to go about it would be to tag the notes with Formula or the like and then find them with a tag search. FWIW. Link to comment
KimHook99 1 Posted September 15, 2016 Author Share Posted September 15, 2016 Thank you. I found the one note I wanted by searching on words that described the formula I wanted. From now on I'll have to remember to add some text to each note, with phrases I might think to use when looking for each specific note down the line. Link to comment
Level 5* CalS 5,284 Posted September 15, 2016 Level 5* Share Posted September 15, 2016 You are welcome. Link to comment
Recommended Posts
Archived
This topic is now archived and is closed to further replies.