Revome blank spacing from ending Numbers
 

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

Revome blank spacing from ending Numbers
 

Use the below formula. Copy it down

=VALUE(TRIM(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Calculate Date range" wrote:

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

Revome blank spacing from ending Numbers
 

Sorry Jacob, the retrun result is #VALUE!

please further advise

thanks


"Jacob Skaria" wrote:

Use the below formula. Copy it down

=VALUE(TRIM(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Calculate Date range" wrote:

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

Revome blank spacing from ending Numbers
 

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

=Trim(A1)

If this post helps click Yes
---------------
Jacob Skaria


"Calculate Date range" wrote:

Sorry Jacob, the retrun result is #VALUE!

please further advise

thanks


"Jacob Skaria" wrote:

Use the below formula. Copy it down

=VALUE(TRIM(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Calculate Date range" wrote:

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

Revome blank spacing from ending Numbers
 

You can also use

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

If this post helps click Yes
---------------
Jacob Skaria


"Calculate Date range" wrote:

Sorry Jacob, the retrun result is #VALUE!

please further advise

thanks


"Jacob Skaria" wrote:

Use the below formula. Copy it down

=VALUE(TRIM(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Calculate Date range" wrote:

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

Revome blank spacing from ending Numbers
 

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
--
David Biddulph

"Calculate Date range" wrote
in message ...
Sorry Jacob, the retrun result is #VALUE!

please further advise

thanks


"Jacob Skaria" wrote:

Use the below formula. Copy it down

=VALUE(TRIM(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Calculate Date range" wrote:

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

Revome blank spacing from ending Numbers
 

Select ur Range

Press CTRL+H

Find What: ALT+0160
Replace With: Blank
OK

NOTE: While Entering the 0160 Hold the ALT Key

"Calculate Date range" wrote:

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