Now you have two options:

Either recreate it again or go through it manually one step at a time, OR Use the 2 formula debugging techniques I am about to share. Keep reading!

Excel Formula Debugging Method #1 – F9 Key

Here is how this works: For example, suppose you have the text TrumpExcel in Cell A1, and in cell A3 you have the following formula:

Excel Formula Debugging Method #2 – Evaluate Formula Step by Step

Other Excel tutorials you may find useful:

!REF# Error in Excel – How to Fix the Reference Error! Use IFERROR with VLOOKUP to Get Rid of #N/A Errors Excel IFERROR Function #NAME Error in Excel – What Causes it and How to Fix it!