Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»Excel Find Function Not Working? Here’s How to Fix it

Excel Find Function Not Working? Here’s How to Fix it

AsmiBy AsmiJanuary 4, 2023
excel find function not working

The Find function in Excel is a text function that returns the position of a set character on a cell item. As the function is tricky to use, many new Excel users experience issues in running the Find function.

The Find function is case-sensitive in nature. This means you need to match the case of the character you want the function to return the value for. If you do not match the case, you might encounter the #VALUE! Error. There are other rookie errors as such that can create problems when using the Find function.

Table of Contents

  • Use Proper Syntax
  • Recheck Your Formula
  • Change start-num Value
  • Use Find Command in Excel
  • Repair Office

Use Proper Syntax

If you do not use proper syntax while entering the FIND function, you will run into the #NAME? error code. The formula for the FIND function is written in the following format:

=FIND(find_text, within_text, [start-num])

You can either refer to a cell or enter a text in place of “find_text”. If you’ve entered text, be sure to enter it inside double quotes. Similarly, be sure to use commas to separate your arguments.

Syntax error find function Excel

In this example, we set the find_text value as I. As we did not enclose it inside double quotes, Excel triggered the #NAME? error.

Correct Find Function Syntax Excel

To solve this, enter your text in double-quotes. The FIND function returns 1 as the letter “I” appears only once in “Image”.

Recheck Your Formula

You could have entered an incorrect value in the find_text section. If Excel cannot find the value you’ve requested in the set cell location, it will return the #VALUE! error.

Check your formula to see if you’ve correctly entered your values. If you’ve used a different case in your formula, change it to match the case.

Value Error Find Function Excel

We’ve entered the find_text value as “A” in the grid above. The FIND function will look for this character in A2, which is “apple”. As the case for the letter “a” is different, the FIND function will not work.

Correct Value Find Function Excel

You can solve this error by changing the case for find_text to “a”.

Change start-num Value

You can add a start-num value at the end of your FIND formula. This specifies a position in the character Excel can start looking for your set value. If you’ve set a start-num value that comes after your set character, Excel will not register that character. 

Start Num Value Error Find Function Excel

For example, we’ve entered our formula to find the number of times the letter “a” has been repeated in apple. However, we’ve set the start-num value to 2, which comes after “a” in the value. Excel cannot locate “a” in the remaining text, so it returns the #VALUE! error. 

Correct Start Num Value Find Function Excel

To fix this, we can change the start-num value to 1. However, you can choose not to enter 1 at all as Excel sets the start-num value to 1 by default.

Use Find Command in Excel

If you’re having trouble using the FIND function in Excel, you can always find the Find command. You can configure the Find command to Match case and Match entire cell contents with the value you enter. 

Similarly, you can adjust where Excel looks for your set value. You can run the Find command within your sheet or the entire workbook. You can also choose if the command searches by rows or columns in formulas, values, or comments.

  1. On your workbook, hit Ctrl + F.
  2. Click on the Options>> button.
    Find Options Excel
  3. Enter your value in the Find what section and configure the search settings accordingly.
    Find Command Search Settings Excel
  4. Select Find All.

The Find command will locate all cells that match your set value.

Repair Office

You could be dealing with corrupt or missing program files if non of the solutions apply. You can perform an online repair on the Office app as your last resort to the Find function not working in Excel.

  1. Open Settings (Windows + I).
  2. Head to Apps > Apps & features.
    Apps and Features
  3. Enter Microsoft Office in the search bar.
  4. Click the three-dot menu and select Modify.
    Modify Office
  5. Choose Online repair > Repair.
    Repair Office
fix
Asmi

Hello! I'm Asmi, and I've been writing professionally since 2020. I'm here to help you learn your way around Microsoft Office-based programs. Besides Office, I also write on technical fixes and general how-to(s). Apart from writing, I like giving back to the community by volunteering.

Related Posts

how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
how to set print area in excel

How to Set Print Area in Excel

January 5, 2023
excel trim function not working

Excel Trim Function not Working? Try these Fixes

January 3, 2023
percentage formula in excel

How to Percentage Formula in Excel

January 2, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
what is ghost of tsushima legends

What is the Ghost of Tsushima Legends Mode

January 12, 2023
raid 5 vs raid 10

RAID 5 Vs RAID 10 – Which One Is Better?

January 12, 2023
best-tv-settings-for-gaming

Best TV Settings for Gaming

January 9, 2023
You may also like
tv-screen-goes-black-randomly

TV Screen Goes Black Randomly? Try These 11 Fixes

January 15, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how-to-open-and-use-chrome-settings

How to Open and Use Chrome Settings

January 16, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Editorial Guidelines
  • Fact-Checking Policy
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday.

Type above and press Enter to search. Press Esc to cancel.