Find position of blank space

I have this in column A:
Mary*Spaunhorst*Ballmann
John Adelhardt
Magelene*Porst*Adelhardt
Elisabeth*Perfling*Altemueller
Ferdinand Altemueller
William J. Altemueller
Frances*Boehm*Ballmann

I used this formula in cell B1:=FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1," ","")))) and copied it down

I am getting the following in column B: #VALUE!
5
#VALUE!
#VALUE!
10
11
#VALUE!

I suspect something hidden is in the cell. How do I figure out what is going on? What do I need to do to not get the #VALUE?

In Excel I do not see the * that is displayed above. What can I do to fix the data?