how to remove the "Space" in cells

[bkcffee]

i have this weird excel file...
i has space at the end

i dont know how to remove it
and i cant even sort properly


thanks in advance

[PFDave]

Strange but try this in column B then paste back over as values.

=LEFT(A2,LEN(A2)-1)

[bkcffee]

ty so much

[PFDave]

You're welcome and thanks for the rep

[avk]

Try with =trim(a2) and copy down.

[avk]

I study in your sheet earlier our formula trim not working some how.
hence i editing formula

Please Login or Register  to view this content.

copy down.
also i mentioned lenght of before formula and after formula.
Now is working. Remove last space.

[bkcffee]

Try with =trim(a2) and copy down.

trim didnt work,, ive tried it before i post here



oh just noticed ur 2nd post

thanks

[shukla.ankur281190]

Or Try

A2

Please Login or Register  to view this content.