Removing spaces from cell with numbers

[danhendo888]

Tried formatting the column to Text, Numbers, General, Currency but cannot seem to remove the spaces
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://ibb.co/kQXF4GV[/FONT]
Both columns are aligned to the left and have spaces in front of them.
[/FONT]

Worksheet Formulas Cell Formula J2 =TRIM(I2) J3 =CLEAN(I3) J4 =SUBSTITUTE(I4," ","") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Any idea how to do it?

 

[sandy666]

post a link to the shared excel file with representative example not a picture

 

[Fluff]

Maybe
=SUBSTITUTE(I4,char(160),"")

 

[danhendo888]

=SUBSTITUTE(I4,char(160),"")

Thank you Fluff, it worked
When I used the formula, it created one space on either side of the number.
I then did a search and replaced the spaces with nothing.

FWIW FYI the spreadsheet in question
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://1drv.ms/x/s!AvjBsEPEq12ngSXcAbrkSBtIo_dl?e=K9Qphn[/FONT]

 

[Fluff]

You're welcome & thanks for the feedback.
However that formula does not add any spaces.

 

[sandy666]

or

Invoice Amount (Net Price)		Invoice Amount (Net Price)
176.80		176.8​
137.60		137.6​
406.59		406.59​
175.22		175.22​
300.00		300​
265.75		265.75​
94.75		94.75​
235.00		235​
658.27		658.27​
245.25		245.25​
908.06		908.06​
673.99		673.99​
749.45		749.45​
204.80		204.8​
523.78		523.78​
751.09		751.09​
334.22		334.22​
267.19		267.19​
487.03		487.03​

[SIZE=1]// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Invoice Amount (Net Price) ", type number}})
in
    Type[/SIZE]