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):

public*string*LineOfBusiness*{*get;*set;*}
public*string*SuspendedTo*{*get;*set;*}
public*string*DbAction*{*get;*set;*}
public*string*OfficeName*{*get;*set;*}
public*string*Priority*{*get;*set;*}
public*string*State*{*get;*set;*}
public*int*PageNumber*{*get;*set;*}
public*int*PageSize*{*get;*set;*}
public*string*SortBy*{*get;*set;*}
public*string*SortDir*{*get;*set;*}
public*string*Status*{*get;*set;*}
public*string*CellPhone*{*get;*set;*}
public*string*ResidentialPhone*{*get;*set;*}
public*string*FirstName*{*get;*set;*}
public*string*LastName*{*get;*set;*}
public*string*Address1*{*get;*set;*}
public*string*Address2*{*get;*set;*}
public*string*City*{*get;*set;*}
public*string*CustomerState*{*get;*set;*}
public*string*Zip*{*get;*set;*}
public*string*PolicyNumber*{*get;*set;*}
public*string*CustomerNumber*{*get;*set;*}
public*string*ScreenPopURL*{*get;*set;*}
public*string*OfficePhoneNumber*{*get;*set;*}
public*string*Carrier*{*get;*set;*}
public*string*TypeOfBusiness*{*get;*set;*}
public*string*CurrentPremium*{*get;*set;*}
public*string*EqualCurrentPremium*{*get;*set;*}
public*string*FromCurrentPremium*{*get;*set;*}
public*string*ToCurrentPremium*{*get;*set;*}
public*string*NextPremium*{*get;*set;*}
public*string*EqualNextPremium*{*get;*set;*}
public*string*FromNextPremium*{*get;*set;*}
public*string*ToNextPremium*{*get;*set;*}