Values with spaces

[Salamullah]

I have a list of amount but it contained spaces before and after figures how can I get only numerical value.


like

100,000
78,900
23,000

 

[oldbrewer]

glad to help !

 

[Salamullah]

Now in a same file Text is also appearing with space so vlookup is not picking value from text, but this time not 2 spaces but different in different cells in some 23 in some 29 spaces at the end of text, please help

Example

Sales
Cost of good sold
Gross Margin

 

[Salamullah]

Please help

 

[oldbrewer]

find space, replace with nothing
and look at trim formula

will look at it in detail in 3 hours time

 

[Salamullah]

find space, replace with nothing
and look at trim formula

will look at it in detail in 3 hours time

have done how you said its removing all spaces instead of all extra spaces appearing and the end of the text.

before
Sales & Marketing Expenses

After
Sales&MarketingExpenses

 

[oldbrewer]

678				3 spaces befor 5 spaces after				693
234				no spaces					249
999				none before 9 after					1014
888				8 before none after					903
								adding 15 to each one, even though there are
								leading and trailing spaces, works fine

<colgroup><col span="13"></colgroup><tbody>
</tbody>