How to remove blank space in cell

[lalaarif1]

Friends,

PFA.

I need to remove the blank space in cell. (col A)
the Output required in given in col. B

The data is huge and doing it manually is very time consuming.

Can you please assist ?

[than_gold]

You can use "Clean" function to remove spaces.

Please refer the link for more info:https://www.ablebits.com/office-addi...-spaces-excel/

[63falcondude]

Try this in B2:

=SUBSTITUTE(A2,CHAR(160),"")+0

[KOKOSEK]

There are not spaces, there are CHAR(160), so TRIM does not working.
Use (into B2):

Please Login or Register  to view this content.

and drag it down as needed.

I've put *1, because you want to sum it, so it have to be 'convert' to number.

[lalaarif1]

Friends...

Wow.... u made my day....
Thanks a lot.

[63falcondude]

You're welcome. Glad we could help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[thealihamza]

Thank you for helping me as well :D