Doing a Find on a " " returns a #Value

I have a list of strings that I copy pasted to excel and when I do a find for a " " (space) character, it returns me a #Value. The formula I used is: =FIND(" ", A1)

Here is what I have tried:
1. Copied the strings and pasted them as Values - Result: Returning #Value
2. Converting the rows of cells into "Text" - Result: Returning #Value
3. Used Search(" ", A1) - Result: Returning #Value
4. Removed all the carriage returns and cleaned up the string by using formula: =CLEAN(TRIM(SUBSTITUTE(SUBSTITUTE(A1,CHAR(13),""),CHAR(10),", "))) - Result: Returning #Value
5. Now I typed the exact same string by hand and it returned me the position number

I can't understand where this went wrong. Is there something that I am missing? I would greatly appreciate some help on this. Thanks in advance.

List of Strings are (Please note that for some reason when i publish this post, "*" is replacing " " character and I am not sure why):

Please Login or Register  to view this content.

Which space character are you searching for? Are you searching only for the standard 32 code, or are you including the 160 space character? My guess is (especially where pasting the text to the forum changed the space character) is that you are searching for the 32 space character, but you actually have 160 space characters. (For that matter, a quick check of a UNICODE data base suggests there are up to 17 or so possible space characters).

I would probably start with something like =UNICODE(MID(text,7,1)) and see what code number one of the space characters returns. Once you know what space character you are searching for, then you can use =FIND(UNICHAR(number),text) to find the correct space character.