I found a macro on the web that does a trim/clean on selection of cells - see below. But the thing is it does NOT work on cells which are longer than roughly 1 sentence or so. Meaning as soon as there's e.g. roughly 2 sentences in a cell or more - it replaces cell's contents with #VALUE (instead of doing trim/clean).
Could any one advice how to fix this?
Please Login or Register to view this content.