HomeHow toHow to remove white space in Excel

How to remove white space in Excel

It is common to open a document in Excel and find excessive spaces between words. In addition to causing some visual discomfort, this formatting can even interfere with your work. Suppose you need to compare cells with the same content. Now, imagine that one of them has an extra spacing — surely the function will fail. To avoid this kind of headache, see How to Remove White Space in Excel.

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

The tutorial below will help you to remove white spaces both between words and to the left or right of your text.

Total Time: 3 minutes

Open the file in Excel

Access the folder where the document is stored and double-click; if you prefer, open Excel, go to “Open” and look for the file;

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

Create a new column to insert clear text

Next to the column with the data that has white space, write a temporary name just to signal that it will be the column with the corrected text — here we name it “Updated”;

Insert the function “Arrange” in the new column

Click on the cell next to the one to be corrected and enter the function “=ARID”; in parentheses place the cell to be cleaned. 
For example: “ = TIME(A2) ”; 
then hit enter on your keyboard;

Use autocompletion for the rest of the column

In the corner of the cell that received the function, it will have a little “+” sign; drag it down to fill the other cells and thus tidy up the entire sheet.

How to delete line breaks and unprintable characters

In addition to those excess spaces, it is possible that a document may also be accompanied by line breaks and unprintable characters. In these cases, just the “Arrange” function will not organize your spreadsheet.

If you tried the above tutorial and still didn’t get the expected result, use “ =TAKE ” to remove that kind of space in Excel.

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

The process is very similar to what we taught above, the only difference is the function itself. So, if you want to remove the special characters from cell A2, for example, add a temporary column beside it and enter the formula “=TAKE(A2)”.

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

George Philip
George Philiphttps://betechwise.com
George Philip is a seasoned tech professional with a deep-rooted passion for all things tech-related. His mission is to demystify complex tech topics and provide you with the insights and knowledge you need to navigate the ever-changing world of technology. With a keen eye for detail and a talent for making the intricate seem simple, George crafts engaging content that explores how technology impacts your daily life, your workplace, and the broader global landscape. Whether you're eager to stay updated on the latest gadgets, intrigued by emerging tech trends, or simply looking to understand how digital innovations shape our world, George's writing is your trusted source for clarity and expertise. Feel free to reach out to George via email at [email protected] for inquiries, collaboration opportunities, or to engage in thought-provoking discussions about the fast-paced world of tech. Stay informed, stay connected, and let George be your guide in the tech-savvy universe.


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

- Advertisment -

Most Popular