I have used trim() to remove trailing and leading space but it removes space towards the right side of the string. It is not removing space of the left side of the string.
I copied the data from my email i pasted in excel and it is giving me result as " 24 "
i would like to see the result as 24 without any space.
Could anyone please help me ?