When downloading data from certain source systems sometimes that source system will append an extra space to your values. The DATE function allows you to create an Excel date based on a year month and day number. For example in the screenshot above the formula in cell E6 is configured to get the position of the value in cell D6.
I tried my best to put together the common issues that many Excel users face from time to time.
That is the third criteria 0which you omitted. Reason 4 Dont Enclose Numbers in Double Quotes. This means find and replace wont work in a protected worksheet. The cell may not be formatted as a correct data type.