Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How to transform empty cells into blank cells in Excel?
I'm trying to use Go To > Special > Blanks in Excell, the problem is that the cells I'm targeting are not blanks. They are just empty.
If I test them with IF(ISBLANK(A2),"True","False"), they return false.
So, how can I turn these into blanks?
1 Answer
- expletive_xomLv 78 years agoFavorite Answer
interesting
it looks blank, but not blank...
maybe you have a character that you just cant see?
- click on a cell
- click the F2 key
- use your keyboard arrow keys to arrow left and right in the cell....
- does the cursor move at all? if not, then something else is wrong....but if you can move the cursor around.....then continue on
- arrow over to the right as far as possible
- hold your Shift key down while you Arrow over to the left 1 click
- click Ctrl C (or your favorite way to copy)
- click Esc
- click Ctrl H (or Edit>Replace...)
- click in the Find what box. and paste (Ctrl V....or your favorite way to paste)
- in the Replace with box....leave it blank
- click Replace all (hopefully it finds stuff and replaces it with real blanks)
then your goto>special>blanks should work
and your formula should show true
good luck.
let me know if that works or not.
