Hello everyone,
Does anyone know if there is a quick way to remove a space from the end of a text cell?
I have a list of names in a column, such as Real Madrid, Osasuna, Tenerife, Celta Vigo, but some of them have a space after the name which is fouling up my attempts to sort them. Because some of them are two words or more I cannot replace the space with nothing.
There are 18 and a half thousand rows in this file, I'm not just being lazy!
Is there a clever way to remove an unwanted space at the end of a text cell that anyone knows of?
Thanks,
Chris.
Does anyone know if there is a quick way to remove a space from the end of a text cell?
I have a list of names in a column, such as Real Madrid, Osasuna, Tenerife, Celta Vigo, but some of them have a space after the name which is fouling up my attempts to sort them. Because some of them are two words or more I cannot replace the space with nothing.
There are 18 and a half thousand rows in this file, I'm not just being lazy!
Is there a clever way to remove an unwanted space at the end of a text cell that anyone knows of?
Thanks,
Chris.