Revome blank spacing from ending Numbers

[Calculate Date range]

need your urgent help

I have a list a numbers as followings with extra bank spacing at the end of
the numbers, please advice me how to set a formula to remove it

40,900.18
1,064.65
3,453.47
6,976.03
3,186.34
6,642.70
6,183.19
8,371.08
3,414.53
8,202.76
3,524.61
3,837.21
3,392.37

Thanks

 

[Jacob Skaria]

Use the below formula. Copy it down

=VALUE(TRIM(A1))

If this post helps click Yes

 

[Calculate Date range]

Sorry Jacob, the retrun result is #VALUE!

please further advise

thanks

 

[Jacob Skaria]

If there are blank spaces at end these must be in text format..Try

=Trim(A1)

If this post helps click Yes

 

[Jacob Skaria]

You can also use

=VALUE(TEXT(A1,"0.00"))

If this post helps click Yes

 

[David Biddulph]

Check whether the characters are actually spaces, or something else.
=CODE(RIGHT(A1)) would return 32 if a space.
If you get 160, it's a non-breaking space, so you may need a substitute
formula or use Edit/ Replace

 

[Hardeep kanwar]

Select ur Range

Press CTRL+H

Find What: ALT+0160
Replace With: Blank
OK

NOTE: While Entering the 0160 Hold the ALT Key