Hello everyone!

I am here to show you how we can deal with the multiple spaces in Ms excel. Of course, you might aware of using a TRIM function that its ability to solve one lead space.

So, how can we remove the multiple spaces in one minute?

We can do of mixing of functions together such as CHAR, SUBSTITUTE, CLEAN, TRIM, VALUE. please try to follow below example then press key Enter:

Capture

=VALUE(TRIM(CLEAN(SUBSTITUTE(B5,CHAR(160),””))))

ជំនាញបច្ចេកទេសគឺជាគ្រឿងផ្សំដ៏ធំសម្រាប់សម្រេចការងារដោយមានប្រសិទ្ធភាពនិងប្រសិទ្ធផល។