I have a bunch of cells with a trailing space after the value. I tried using =clean however this did not remove it. Does anyone know another way of removing that?
Asked
Active
Viewed 55 times
0
-
3Use `=TRIM(A1)` – Scott Craner Jan 03 '20 at 16:47
-
2If trim does not work alone try `=TRIM(CLEAN(A1))` – Scott Craner Jan 03 '20 at 16:49
-
That did it, thank you!! – ThisGuyUsesPowershell Jan 03 '20 at 16:54