Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Remove Blanks In Excel Cells?

Date:2022-4-4 Author:Sandra

Do you know how to quickly delete or remove blanks in the cell?  There are three different scenarios. So we are going to know how to delete useless blanks in different ways.

No.1

I want to search the scores of HappyMaryy, Excel, and Do. But when I enter these names into. No score result shows up.

One clear reason is that the names in column A contain several blanks. So how to quickly delete these blanks?

How To Remove Blanks In Excel Cells?

Select column A and press Ctrl and F to open the Find and Replace window. Press the Blank key in Find what and hit Replace All.

How To Remove Blanks In Excel Cells?
How To Remove Blanks In Excel Cells?

No.2

There are blanks between numbers. If we use the same way in No.1.

How To Remove Blanks In Excel Cells?
How To Remove Blanks In Excel Cells?
How To Remove Blanks In Excel Cells?

We can clearly see that the last three would become zeroes. After the replacement, the cell format is converted to a numeric value, and the maximum length of the valid value stored in the cell is 15 digits, which results in the last three digits of the 18 digits being converted to 0. So, it’s not working.

What we need to do is find any cell and enter [‘] in. Then click the Format Painter to make the numbers cells apply this format. Then try the replacement again.

How To Remove Blanks In Excel Cells?

No.3

If we want to make the texts into one sentence or just left one blank. The ways in No.1 and No.2

are obviously not applicable.

Press =TRIM(A2) in cell B2 and press Enter key.

How To Remove Blanks In Excel Cells?

Then use the fill handle to fill it.

How To Remove Blanks In Excel Cells?
How To Remove Blanks In Excel Cells?
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *