spaces after figures

[Salamullah]

Hi,

I received 1 excel file contained values but having 2 or 3 spaces after figures, I think this is formatting issue, what formula can I apply to get figures only.

In the below example x means space

Current figures
100xx
300xxx
210x

Wanted
100
300
210

 

[footoo]

https://www.google.com/search?q=exc...j69i57j0l4.20072j0j8&sourceid=chrome&ie=UTF-8

 

[Michael M]

Use

Excel 2013/2016
	A	B
1	100	100
2	300	300
3	210	210
Sheet1

Cell Formulas
Range	Formula
B1	=TRIM(A1)

 

[Salamullah]

Many thanks for your quick help but I don't know why in B1 its giving again 100x

 

[sandy666]

maybe =CLEAN(TRIM(A1))
or
=SUBSTITUTE(CLEAN(TRIM(A1)),CHAR(160),"")

 

[Michael M]

You could also do this with a simple Find / Replace
Highlight the data >>Editing Tab>>Replace>>In the Find box Hold down the ALT Key and using the Number keypad type 0160>>Leave the Replace box blank>>Replace ALL