"Providing Denver Businesses with the highest quality Printing and Branding Solutions"
For all your print needs
MetroGraphics
MetroGraphics
[CDATA[ */ The other SUBSTITUTE function will replace all space characters with empty text. I earn a small commission if you buy any products using my affiliate links to Amazon.
Again, click OK and Replace All. Use the TRIM Function to Remove Tab Space, 3. Finally, we can see in the Salary Using SUBSTITUTE Function column, that there are no spaces between the numbers of salary. We hope you will find this article helpful. To select the cells that we want to convert to text, we must not have more than one column. It is the Trim formula. In this method, we will create a formula combining the TRIM, SUBSTITUTE, and CHAR functions. We can also delete spaces with the help of the Substitute function. We can do this using Copy & Paste. } After that, you will need to put in how many spaces you want to replace the existing spaces in Replace with. Here, I gave single spaces. Hence, it will remove all white spaces and non-printing characters from the selected cell.