Convert text numbers to numbers

[Tagaffney]

Can't convert these text numbers to numbers. Tried all possible methods, no luck

8.75
17.51
23.96
30.55
34.99
10.94
8.75
10.94
39.29

Numbers copied from a SODA PDF excel conversion spreadsheet of a Bank Statement PDF download.

 

[Dave Patton]

Did you read post #4 ?

When I put your sample data into a sheet, it showed that most of the data had Char 160 at the right of the numbers,
The formula works.
If you remove the char 160, you can coerce the text to a number.

Replace non-breaking spaces with regular spaces. Using the SUBSTITUTE and CHAR functions, substitute character 32 for character 160. Example: =SUBSTITUTE(BadString,CHAR(160),CHAR(32)).

or substitute with 0

=SUBSTITUTE(A1,CHAR(160),0)+0

 

[Tagaffney]

>=ISTEXT(A1)
<=CODE(C2)
<=RIGHT(A3)
Number <=IF(ISNUMBER(A2),A2,LEFT(A2,LEN(A2)-1)+0)
8.75 #VALUE ! 32 TRUE
10.78 #VALUE ! 32 TRUE
353.44 #VALUE ! 32 TRUE


This seems to work, but too cumbersome:

+0 =ENTER
8.75 8.75+0 $8.75
10.78 10.78+0 $10.78
353.44 353.44 +0 $354.44
>=ISNUMBER() >=ISNUMBER() >=ISNUMBER()
FALSE FALSE TRUE

 

[Tagaffney]

What is the character to the right of the number?

To Dave Patton,
Thanks for your help. I realized that character was an extra blank (space?, your 160?) in all the numbered cells. Once removed, all became numbers. Thanks. Tom