Can the Trim fuction be modified to remove all spaces between text, instead of leaving one space? Or is there another automated way to remove that remaining space?
Edit, Replace and then in the Find field type a space and then to take the space out of the desired cell, click Find Next till you get to that cell and then click Replace.
If that doesn't work, then we have to look for other things.
I tried putting " " in the find before and it didn't work. So I tried typing a space as you suggested and it still didn't work. When I unchecked "Find entire Cells only" it started working. Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.