remove space and blank

[lassaad.toukabri]

Dear all

i would like to remove space in excel colums
Example:
if number is 3 705,490 ,i would like to keep it like this : 3705,490
I try TRIM,CLEAN ,Replace space and same problem

Thank You

[Olly]

Try:

Please Login or Register  to view this content.

Or to convert it to a number:

Please Login or Register  to view this content.

[lassaad.toukabri]

this is my example in attachement ,you can check it

i test with 2 solution that you provide but same problem

[benishiryo]

welcome to the forum. try:
=--SUBSTITUTE(A1,CHAR(160),"")

those spaces you have are called non-breaking spaces. they are not your regular spaces. usually found when download from somewhere

[lassaad.toukabri]

Thank You ,it s working

[lechefox]

welcome to the forum. try:
=--SUBSTITUTE(A1,CHAR(160),"")

those spaces you have are called non-breaking spaces. they are not your regular spaces. usually found when download from somewhere

-----

I have the same issue but the data is a mixture of characters and integers - is there a similar solution