FIND not working in Excel? Which one was your problem?
Reasons your FIND tool in Excel is not finding an item that you can clearly see is there. Tell us which one was your problem.
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- online-excel-training.auditex...
🇿🇦- Our main website- www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 FIND not finding something that is there
00:15 FIND not looking in the correct area
00:52 FIND looking IN the formula NOT the resultant value
02:03 FIND not finding dates (typically months) or numbers
02:58 FINDing ? or *
03:40 FIND also looking for the formatting of a cell
04:25 UPPERCASE vs any casing in FIND
04:58 Matching entire cell contents but you are finding for partial contents
05:40 FIND searching in Notes/ Comments and NOT the spreadsheet
Пікірлер: 79
Buy us a coffee ( ☕ ) if we have saved you time via the Super Thanks. Makes it easier to keep these tips coming every day!
Thank you for explaining the entirety of the find feature and its quirks. Huge help!
@Advanced_Excel
Жыл бұрын
Pleasure. Which one is the one that causes you most problems?
very clear, highlighted mouse, and paced perfectly, thank you!
@Advanced_Excel
Жыл бұрын
Pleasure. Which one was the reason that FIND wasn't working for you.
Many thanks for releasing the second part of the day from the headache!
@Advanced_Excel
Жыл бұрын
Glad I could help. Which one solved your FIND problem.
Thank you SO much! Helped me tremendously after not know what was going on. Mine was the 3rd issue where it was looking for a formula instead of value.
@Advanced_Excel
Жыл бұрын
Glad it helped you. Between that one and the one where it is looking for a format as well, FIND can look like it is giving the wrong answer often.
Thanks, you help me a lot. Especially "Clear Format"
@Advanced_Excel
5 ай бұрын
Glad to hear that!
Thank you - this helped me - it was the preview format.
@Advanced_Excel
3 ай бұрын
Glad it helped!
Thank you! This quickly solved my issue.
@Advanced_Excel
5 ай бұрын
Great to hear! Which one was your issue
Thank you so much for this! I was using excel to store the words I'm learning in another language. This language uses glottal stops and the apostrophes in words (used to represent the glottal stop) were preventing the search function from working, so learning I could use asterisks was helpful! It worked!
@Advanced_Excel
4 ай бұрын
Great to hear. Didn't think of that use for FIND
AMAZINGLY HELPFUL!!!!!!!!!!!!!!!!! THANK YOU!!!
@Advanced_Excel
Жыл бұрын
Glad it helped. Which one was the reason your FIND was not working in Excel
Thank you - very clear and concise :)
@Advanced_Excel
11 ай бұрын
Glad it was helpful! Which one was the reason your Excel FIND wasn't working?
Huge help, thanks 👍
@Advanced_Excel
Жыл бұрын
Pleasure. Which was the one that was giving you a problem?
THANK YOU sooo much, I did not know the default was look in Formulas. Changed to values and bingo, search is working.
@Advanced_Excel
Жыл бұрын
Pleasure. Just be careful because once you change to values it tends to stay values and you might want to sometimes search in formula.
thanks!, you save my life bro
@Advanced_Excel
Жыл бұрын
Glad to hear that. Which one was the reason for you that the FIND wasn't working in Excel?
Thank you! Was driving me nuts.
@Advanced_Excel
2 жыл бұрын
Great. Which one was the one that affected you? Trying to get a sense of which are the most common issues.
@david_1956
2 жыл бұрын
@@Advanced_Excel For me, it was trying to "find" not knowing that a format was set.
Thank you!
@Advanced_Excel
7 ай бұрын
You're welcome! Which one was your issue?
You are a lifesaver!
@Advanced_Excel
2 жыл бұрын
Thanks. Which one was your problem area?
@Brainbuster
2 жыл бұрын
@@Advanced_Excel At 4:04, clicking the tiny arrow at the right of the little Format box. Then click *Clear Find Format*.
@Advanced_Excel
2 жыл бұрын
@Brainbuster thanks. Still catches me out every time. It should turn bright red if active to be more easily noticeable.
@deepakjha9504
Жыл бұрын
@@Brainbuster Same problem here. Thanks
you are a legend
@Advanced_Excel
11 ай бұрын
Glad it helped- which one was the reason you FIND didn't work in Excel?
@btroll4041
11 ай бұрын
@@Advanced_Excel it was the option, it was selected formula i changed it to value and it worked immediately
Thank you.
@Advanced_Excel
7 ай бұрын
You're welcome! Which one was your issue?
clear and helpful
@Advanced_Excel
Жыл бұрын
Thanks. Which reason explained your FIND issue in Excel?
Thank you
@Advanced_Excel
8 ай бұрын
You're welcome. Which one have you the problem
thanks that worked
@Advanced_Excel
Жыл бұрын
Which one was the reason your FIND wasn't working in Excel
Thanks ❤
@Advanced_Excel
Жыл бұрын
Pleasure. Which one was the reason that find in Excel didn't work for you
Thnks
@Advanced_Excel
Жыл бұрын
Pleasure. Which one was your reason for the FIND/ REPLACE not working?
When using Find and Select, mine is missing features. I only am able to see "Find","Replace", and "Go To" under the Find and Select Tab.
@Advanced_Excel
8 ай бұрын
What version of Excel are you using? Do you see the other features but they are greyed out or are they not there at all?
@HugoStigglitzs
8 ай бұрын
@@Advanced_Excel yeah Im using the trial version and watching your videos it seems Im missing some stuff maybe.
Thanks bro
@Advanced_Excel
Жыл бұрын
No problem. Which one solved your problem?
@iwinner1718
Жыл бұрын
@@Advanced_Excel The match case one, I don't know how I managed to check that :D
@Advanced_Excel
Жыл бұрын
Thanks
After some change/update to new version of Excel doesn't work properly find if you mark more than one sheet, you have to search in each sheet separately.
@Advanced_Excel
2 жыл бұрын
You need to change the one drop down from sheet to workbook. Nothing has changed on my version. Which version of excel are you using?
@chrisk.9765
2 жыл бұрын
@@Advanced_Excel I mean change from some old excel perhaps 97 to 2016/2019. Macro written in the old excel doesn't work properly with new version (some changes in the code were needed). Macro were written just by "recording on live" As I know in the meantime Microsoft made changes in Excel VBA language and few functions were changed/removed.
@Advanced_Excel
2 жыл бұрын
@@chrisk.9765 This is for the FIND tool in Excel. Macros have additional risks of not working version to version
Trying to find phone numbers is a pain in the arse. Numbers that were from a CSV now saved as an excel but they have spaces in them. Its a pain.
@Advanced_Excel
4 ай бұрын
Perhaps have a look at kzread.info/dash/bejne/mqaNo6uEYpfWm9Y.html which shows how to use wild card characters to find parts of a phone number.
@TheStevenWhiting
4 ай бұрын
@@Advanced_ExcelSadly not working. The phone number has spaces. I type the number with no spaces and put * in front and still doesn't find it. I remove the spaces and it removes the leading 0 of the original number. Same search, still doesn't find it. I have to remove the leading zero from the search for it to find it. Its odd.
@TheStevenWhiting
4 ай бұрын
@@Advanced_ExcelThink got it. Had to use substitute to remove the spaces. Then copy the numbers that came from the forumla into another sheet. Then the search works.
I was having issues with getting the Find button to work even after watching this video. I discovered that if your cell borders are selected the Find feature will NOT work! As soon as I removed the borders the Find feature worked again! Seems like a bug to me.
@Advanced_Excel
Жыл бұрын
Thanks for sharing. Can you by chance send us an example. This would be the case as well if the format FIND was set to a cell with no borders, but I haven't seen it happen when the Format FIND is not on.
Thanks for the video. My problem is there is NO option other than Formulas. The drop is otherwise blank. Please help!
@Advanced_Excel
Жыл бұрын
You can only use values when you are in the FIND screen. If you are in the REPLACE screen it is not available.
@jabrielhasan5150
Жыл бұрын
@@Advanced_Excel thank you! How would you do a simply "Find & Replace" for replacing a date? I have never had this problem before. Older versions this wasn't and issue. As Microsoft improves these functions. Simple functions seem to be becoming less simple. :/
@Advanced_Excel
Жыл бұрын
Is the date created by a formula or is it a value and what are you trying to replace, the full date or part of it e.g. the month only?
@jabrielhasan5150
Жыл бұрын
@@Advanced_Excel The date is formatted to mm/dd/yy and is simply keyed in. It is not created by a formula. I am only trying to replace mm/dd/yy with another date in the same format mm/dd/yy. FYI: Actual date when you click on the cell appears as 3/25/2021, but is formatted to 03/25/21. I hope this helps. Let me know. Thank you
@Advanced_Excel
Жыл бұрын
It seems to work fine on mine. I created a number of dates e.g. 2023/03/15 and 1 day extra for a number of cells. Formatted it as 23/05/15. When I do a Find/ Replace it finds the correct date and replaces it with my correct date. The only thing I needed to be careful of was the search for what is in the formula bar and not what you see in the cell.
My problem is can't find a word with in merge and center
@Advanced_Excel
2 жыл бұрын
Merge and centre shouldn't be a problem. Have you tried looking in values rather than formula?